I'm going compact a few things already mentioned and hopefully repeat them but in a different way.
The two most important things: 1) Skill and control. 2) Situational awareness. Altitude by itself isn't one of them. As someone else alluded to, with some exceptions, the higher you go the more boring the footage. What makes UAV footage so interesting besides the perspective of altitude is the smoothness at which you can pass over and between things that would be impossible without special ground equipment- or just impossible from a ground-bound camera. The closer you get to stuff the more skill and control you have to have. It doesn't take much skill to stay away from stuff at 300', but when you have 3' on either side of your drone it's a different story. Also a perfectly functioning and stable drone is critical. Having the settings right for stick sensitivity and the motion response of your drone, adding in the personal skill contributes to it all.
Situationals awareness is critical as you want to know where stuff is before flying, or at least be able to identify where it is. How high do you need to go to avoid obstacles. Google Earth is extremely helpful in determining things such as RTH altitudes. Sideways motions is always tricky when below altitudes where obstacles may reside. Even for pilots with decent skills it is so easy to misjudge what is positioned laterally to your drone. At least in descent you can point the camera down to see what's directly below.
It is interesting to me that while VLOS with naked eyesight is mandated by the FAA (without a VO) I find that I tend to be more spacially aware with
goggles on even though I'm looking at essentially identically the same screen as my phone would show me. I think FPV with
goggles is more helpful flying near obstacles than just flying off of the phone screen unless I can be directly in line with the drone. However, even being in line if the drone is more than a few feet away I'm better off with
goggles for the most part. That's probably just me, and perhaps
goggles just help me stay focused on the trajectory and help me identify objects in my path quicker and more effectively than with the phone's screen. And up in the air you do have to be more situationally aware of things that might be in the sky with you.
The thing is that if you don't push the envelope a bit this all gets boring very fast.
Edit: Here's me pushing the envelope in a practice session over an unpopulated golf course practicing low level maneuvers. I needed to make an S turn to continue between the trees and thought I'd gone far enough past the first tree for clearance. The mistake I made was using the left joystick too early as I didn't want to rely solely on yaw... and paid the price. I *thought* I had cleared the tree. It cost me a set of propellers. Perhaps
FPV goggles would have been better for me in this instance? But this is an instance of practicing, pushing the envelope with limited risk. I couldn't have gotten the same experience 300' AGL. You can't develop skill through osmosis.