The best view of Deep Space Nine station from within can be found in the control gondolas at the extreme ends of docking pylons.
When a night shift worker is assigned to the control gondola of a pylon, we usually linger at the observation windows. They’re much bigger than the windows on the Promenade. You can see the whole structure of Deep Space Nine, barring the pylon you’re in, from an observation window. Sometimes you can even see Bajor or the wormhole, outshining the many small lights of DS9 as a sun outshines the candles in a temple. If you’re in a lower pylon, you can sometimes see other people, their tiny bodies barely visible, in the window of an upper pylon, or vice versa.
The gondolas are technically not public areas, so night shift workers eagerly claim the privilege of legally using the observation windows whenever we can. It’s easy to sneak in through access tunnels, though; the Cardassians didn’t want Bajoran workers to be able to easily take over and hold all the docking ports, so they gave themselves secret passages. Now those passages are used by stargazers to sneak into the control gondola. Station Security doesn’t mess with people that just want to have a better view of the stars.
Smugglers use the tunnels too, but there are sensors to detect life-forms moving out of the control gondola to the docking ports or airlock assemblies. Just stay at the windows and you’ll be fine.