If you just want a photography drone and can live with short range and only 1080p video something small and self flying like the Ryze Tello is a good place to start, they are relatively cheap and basic. There’s a lot of consumer photo drones around now, there’s lots of YouTube channels that test them. Kids can fly these smaller, less powerful platforms quite safely and some get under the 250g registration limit that many countries seem to have settled on.
If you want more features and better video with a compact size and major manufacturer support a second hand DJI spark is hard to beat price wise.
The sort of drones most people here fly are almost entirely pilot controlled and designed with performance in mind, with not so much emphasis on automation. You really fly those, they are not a photography or static camera platform.
With restrictive regulations everywhere it might pay to look at how much hassle with registration etc you want before you get set on buying as well, check the rules where you live and look at where you are allowed to fly.