My experience is different. Sensitive camera with a fast lens feels sort of like a night vision. In my case sony a7iii + 1.4 24mm lens can see so much more stars in Berlin. And that's on relatively fast shutter speed (hand handled) with no processing. Yes longer shutter speeds, contrast boosting, stacking etc then multiple this effect to another level.