How good or bad a show like this would be depends entirely on the characters. When DS9 came out people had the same reactions, who wants to see Starfleet Officers stuck on a space station? But the excellent writing and well developed characters made it work.
And the badass starship and a war with lots of ships shooting lots of weapons at each other...
And it still isn't popular outside a narrow band of Trek fans.
It's pointless to come up with idea for shows and movies that would never actually be made because of the fact that the studio is in business to turn a profit. The more something looks like DS9 or the other later Trek shows the less likely it is to be considered.