Re: Earth based Trek show
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.
"If we're going to be damned, let's be damned for what we really are." - Jean-Luc Picard, "Encounter at Farpoint"