I would like the adventures of the Enterprise-J, but to really make it work it has to have a comprehensive philosophy of the future.
Structurally I would want it like ENT season 4 with a bunch of two-part episodes, but with an over arching plot where, a little like DIS, some of the episodes and two-parters are tied together in a finale. It should use the Orville's use of B-plots to build characterization and character arcs and explore personal consequences, and like Agame ga Kill it can kill off primary characters to build the characterization and arcs of the remaining cast.
I would build the whole thing around the idea of the crew regularly rotating due to death and promotion onto and off of the ship. It would not be happening every few episodes, but after a few years the captain would definitely be promoted off and a new one would come in. It wouldn't be about any particular person for the whole show, but major arcs might belong to one or more people.
Because it would be the size of a large city, where ever it goes it would also have a ton of traffic like DS9, and ships might be continuously rendezvousing with it even when moving faster than light. So it would mix the elements of going to meet interesting people, and interesting people coming to meet them. It would also lean heavily on the civilian population idea, with the vast majority of people on board being explicitly civilian passengers and the whole thing being like a city state.
The key to making it work is deciding if it is a military dictatorship, as in it is a Starfleet city ship run by Starfleet personnel with only minimal or no passenger input, or is it a civilian ship run by Starfleet, where the passengers have in some capacity the powers of commander in chief and it is up to Starfleet personnel to decide how to act on those orders.
