unless you're flying tiny whoop style quads it can get very expensive
micro quads for flying indoors are cheap and great fun for the times you cant get out the house, i use a eachine e010 about £15
then you have larger "toy grade" quads, these are easy to fly, are self leveling, camera quality is okish, range isnt great and can be prone to flyaway if the signal is lost £30-£150
for photos and video DJI is probably the best option, they go from the Spark, Mavic to Phanton and cost £300+
DJIs are easy to fly, but more focus on photos and video rather than having fun flying
if you want to be a true pilot then fpv freestyle/race quads would be best, this is what i do and is quite expensive to get started
transmitter £100-250 but works on all future quads
fpv googles £100-400 same as above
the quad itself £100+ depending on what parts you use
diy quads are best in my opinion, you build it to your needs, and if something breaks and it will break you can fix it quite easily