Just about every lens choice is a compromise of some type. A zoom lens will rarely be as good as a prime (non-zoom) lens...but of course, the zoom can change it's focal length. Many zoom lenses, especially the less expensive ones, have rather small maximum apertures...which makes it hard to get fast shutter speeds...and you need fast shutter speeds when shooting action (sports) or anything in lower light.
The better zoom lenses and many prime lenses have larger maximum apertures (F2.8 for zooms and often bigger (F1.8) for primes). This too is a compromise because lenses with large apertures are bigger, heavier and more expensive.
Of course, for most people, cost is an issue...so when you can't afford the best tool for the job, you are making a compromise in some way...image and/or build quality for example.
You may need to think about what type of shooting is more important to you, and see what you can afford in that area. For example, wildlife and surfing will probably require a long lens...maybe around 300mm. You can get a cheap 70-300mm zoom lens for less than $200...but there are a few compromises. There are several better options...but not many for less than $400.