I'd be for a space station show. It allows for greater exploration of a smaller part of the universe. I'd also be up for a spinoff showing the life on a newly founded colony world. By now the technology to make that feasible might be around, considering t hat Star Trek is switching to digital environments (at least that's what I read around here)
So have a bunch of people live on an exotic alien planet and work out ways to survive the environment and grow as a community.
Only if there's a way to avoid mystery box storytelling.
I mean nothing against the idea in a vacuum, but we already have two Trek shows right now that employ mystery-box storytelling, why make a third?
So please no "Ooooh let's spend 10 episodes finding out who built this space station! (hint: the reveal will be very underwhelming, because we're making it up as we're going along and stretch it out as much as possible!)"
If the mystery box can be avoided, I could see something like a federation outpost inside a vast, ancient space station, left behind by a former civilization, with other empires and communities living in other corners of a mostly abandoned mega structure like that.