"Good" is highly subjective. If you look on any serious photo forums they will probably tell you it is no good, because those are the kind of people who do test shots of line charts and blow it up 500 percent to check lens sharpness. In other words, things no one in real life would actually use a lens for.
For your purposes it may be fine. I am a finicky semi-pro photographer who routinely blows photos up to 24x36 inches and bigger, so for me it would not work. But if you are doing standard prints (say up to 8x10 or 11x14 inches) or posting them online, it should be ok.
You may want to rent one first. Alternatively, if you are buying it at a local shop, take your camera in and do some photos in the store and then check them at home before purchasing the lens.
Unfortunately, there is no other cheap way to get to 500mm. The dedicated 500 f/4 lenses cost as much as a new compact automobile.
If you want long reach and professional quality sharpness, the best lens for the money (if you use Canon) is the 400 f/5.6L, but it is not a zoom.