The good news is, I think, there aren't many (if any) truly dreadful cameras any more.
The bad news is that it's still easy to take a great camera and take dreadful images.
But there is a world of difference between a compact and a DSLR plus a zoom lens.
As a comparison here's the moon pic that
@AndrewFlannigan posted above next to one I took with a Canon 600d and an EF70-300 lens. Mines's quite a heavy crop. I suspect Andrew's is a severe crop. If you click the picture you can go to Flickr and see the image a little better. But there's no denying there's a tonne of additional detail in the one from the DSLR.
IMG_5828.crop by
Kell Lunam-Cowan, on Flickr
The better news is that you don't have to spend a fortune to get set up with a very capable rig. Anything over 300mm is likely to cost you a lot more. But canon produce a cheaper - i.e. mostly plastic EF (so fits crop and FF cameras) 70-300. It's lightweight and easier to take places. In my experience, it's a better performer than the 75-300mm version
I did have one, but sold it when I upgraded to the 100-400. The extra reach is noticeable, but it is heavier, bulkier and far less likely to come with me on a walk.
this is the lens I used to have:
https://www.mpb.com/en-uk/used-equi...canon-ef-70-300mm-f-4-5-6-is-usm/sku-1409345/ (they're cheaper on ebay)
A SH Canon 5D (classic) and an EF 70-300 lens should set you back about £350. And you don't even need to go for a full frame camera. I had a 20D which I bought for £50 and I loved it. Even though it was an older camera than my 600D, it somehow produced much cleaner images. I sold my 70-300mm lens for around £150. So you could be up and running for £200 with a pretty capable set up.
My 20D gallery:
https://flic.kr/s/aHsmA7Zjww
My 5D Classic Gallery:
https://flic.kr/s/aHsmLUDi35
My 70-300 gallery:
https://flic.kr/s/aHsmWWVV9h
(PS - I set up these galleries for when i was selling each of those bits of kit - just haven't got around to deleting them.)
The next problem you might run into it is actually being able to utilise the tech. If you're going to get a DSLR and know nothing about photography, the best investment you could make is a camera course. Being able to understand and use shutter speed, aperture and ISO correctly on old tech will do more for your final results than buying a brand new camera and knowing nothing about how to make it go.