Living in the UK, finding a dark sky spot away from all the light pollution is as hard as finding a cloudless moonless night, let alone a cloudless moonless night under solar activity conditions suitable for intense aurora activity at our latitude. Yet on a clear night far away from the city lights (fortunately there is a darkish sky spot about an hour's drive away from my house) you can see so much depth in the night sky, and seeing the entirety of Ursa Major (not just the Plough) before you for the first time is a staggering experience.
An even more mindblowing experience was seeing the Southern Constellations for the first time. A while ago I was in New Zealand on holiday, and in an isolated spot on North Island, it was incredible to see with my own eyes new and unfamiliar constellations I only ever read about in books, such as Crux and Centaurus. Even better, the Milky Way was out in force that night, and to see the core region and inner arms light up the night sky in the southern hemisphere was one of the most memorable sights I've seen.