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.
"...the most elementary and valuable statement in science, the beginning of wisdom, is I do not know." - Lt. Commander Data, "Where Silence Has Lease"