Most “cheap red dots” from major name brands seem to do just fine in casual applications.
The “mistake” you might make, if there is one to be made, is buying a particular model with a feature set which doesn’t match your desired use. For example - the Bushnell First Strike red dot is an inexpensive RDS, and I have been very happy with a couple of them on range rifles. However, after using mine, a friend bought one for his hunting rifle, but then realized it is light activated, so it won’t turn on during the low-light hours of dusk and dawn.
Similarly, some models are automatically dimmed or intensified by ambient light, and shooting in certain conditions - like a poorly lit range station at well illuminated targets down range might leave your dot insufficiently bright. Some models go-to sleep, some “shake awake,” some have manual controls which must be toggled through 6 brightness settings just to turn off... some have big 8-12moa dots, some have 2-3 MOA dots, some are green, some are yellow, some are red...
Decide which features you actually want, then pick the brand name sight - however cheap it might be - which best lines up with those features.