You won’t see anything like that with the naked eye, period. We can’t build up a composite of all photons our eye gathers over 1060 hours! There are places where you can get minimal light pollution and see amazing things though.

https://darksitefinder.com/map/

That site will help.