Somewhat off-topic, but if like you these sorts of views and have some spare money, I recommend trying a drone with goggles. When it comes to safety, some new drones already have ADS-B receivers and hopefully remote ID transponders will come soon.
If I want to fly something heavier than 250g, with goggles, what kind of FCC license do I need?
The problem for me has been city ordinance. My city is urban sprawl and it's illegal in my city to fly in parks, or over people. So that rules out pretty much everything interesting.
If you are into the whole racing quadcopters thing, there are options, but FPV exploration was what I liked.
https://www.faa.gov/uas/media/Part_107_Summary.pdf
https://www.faa.gov/uas/recreational_fliers/
https://jrupprechtlaw.com/section-107-31-visual-line-sight-a...
From what I understand, you should have a visual observer or obtain a Remote Pilot Certificate. IANAL.
My dream is a setup like that which can truly transport me to the drone as if I was flying fpv but with the ability to move my head and camera independently of the drone.
You'll pay about as much for the goggles as for the entry level drone. Budget some for an extra battery.