Weng's ideal Star Trek:
Set sometime after the rollout of the Sovereign class as a mainline vessel.
Borg == gone. Let Voyager have had their fun.
Invent a new interstellar alliance. Think of it as the Federation; similar size, similar people, except with expansionist ideals and similar technical levels. No gimmicky races.
Have them stage an incursion on Klingon/Romulan turf.
Klingons/Romulans forge an uneasy alliance
Federation jumps in to do the right thing and help out and all that crap.
Make it so that the viewer can identify with both the Federation and the unnamed enemy force
Make them... Very human.
Focus on a single Sovereign class ship which heads up a battle group. NO old characters.
Concept for pilot episode (which, for epic purposes, should actually be 3-4 episodes):
Several months have past since the violent first contact between the Klingons and this alliance. Klingon/Romulan treaty has been signed, they're actually cooperating on a governmental level, though it's still not a good idea to put Klingon and Romulan assets in the same place at the same time, as individuals still attempt to knock each other off. The Klingons have done fairly well holding off the invasion, but the Romulans have lost several worlds in a very short time.
The Federation sent an envoy shortly after the initiation of hostilities; this envoy was captured and killed, and his ship's computer exploited. Romulan intelligence reports that the enemy's primary goal is now to conquer the Federation worlds, but not until after the Klingons and Romulans have been dealt with.
To counter this reported threat, Federation officials instructed Starfleet to assemble and prepare for a defensive war. The first three battlegroups prepared assembled at Sector 001 (aka Earth) and consist of the Federation's ENTIRE inventory of Sovereign vessels and numerous support ships, mainly Akiras and Galaxies. One group is to remain behind as a permanent defensive installation. The other two are to proceed immediately to the Romulan/[unnamed] lines and do whatever is neccessary. The first group is headed by the Enterprise E (with very little of the crew that we know on it, most of them have transferred or been promoted or have their own commands). The second is headed by our protagonist ship. While en-route, the battlegroups recieve reports of a Klingon armada being sent as reinforcements to the Romulans are ambushed by Romulan defenders. The protagonist ship's group is diverted to break up the conflict.
In a SPECTACULAR epic battle sequence, the Enterprise E and it's entire battlegroup are annhilated at the hands of superior enemy numbers. The vastly weakened enemy continues pressing the Romulans and enter orbit of a Romulan world after knocking off the last of the defenders.
After forcing the Klingons and Romulans to remember that they're ALL going to die if they don't knock it off, the combined Klingon/Romulan/Federation Battlegroup 2 proceed to the last known position of Battlegroup 1. They stumble upon wreckage that makes Wolf 359 look like a cakewalk. Naturally, the enemy has taken every single escape pod and are holding them as human shields/prisoners/whatever. The forces then turn to avenge their fallen comrades. The examination of a recovered Romulan computer core reveals that shortly before being destroyed, the crew of that vessel had discovered that there is a small weakness in the shielding used by the enemy which would allow FEDERATION transporters to penetrate with minor modifications. This facilitates an insane rescue mission and the capture of several enemy vessels.
Throughout the series, to mix things up, periodically both sides will discover chinks in the other's armor, which will work a few times, and then be sealed forever.
This rolls everything Star Trek fans love into one: Epic space conflict, political tension, scientific mumbo-jumbo, and with emphasis on the single ship with it's set crew, emotion, love, death, drama. As the series plays out, even exploration will come into play as the Federation decides to continue pushing them back and ensure the destruction of this near-fatal enemy. The destruction of the Enterprise E will of course be a trauma, but will pave the way for the introduction of an even more formidible warship with it's prototype carrying the flag NCC-1701-F, designed for hard ship-to-ship and planet-to-planet infantry battles, fire support, and other warfare roles, instead of the Sovereign's intended role of fighting off the Borg at a distance. Middle of the show's run, the crew of the protagonist vessel should be transferred to the Enterprise F.