I can totally relate to what you’re describing. The vertigo you mention reminds me of the Total Perspective Vortex [0] from the “Hitchiker’s Guide to the Galaxy” books by Douglas Adams.
I totally agree about seeing the Milky Way, the rings of Saturn or the Andromeda galaxy with your own eyes (with the help of binoculars or a small telescope). This really gives you a different perspective on our existence, life and the grand scale of things.
One last piece of advice to aspiring astrophotographers, this is an expensive hobby and an addictive “disease” :-)
[0] https://hitchhikers.fandom.com/wiki/Total_Perspective_Vortex