My favorite is the Ambassador class. Has the look of the original Constitution Class but with a modern touch.
My favorite is the updated USS Excelsior which seemed to get a healthy dose of Galaxy Class technology.
Also I dont think any ship would have survived Narenda III. The Enterprise C was ambushed by four Warbirds.
Its to the Enterprise C's credit that the Romulans were impressed enough with her technology and fighting ability that they did not mess with the Federation for twenty some years. Guessing she put up a hell of a fight and gave the Romulans something to think about.
IIRC Before the timeline was restored the Galaxy class Enterprise wasnt fairing too well either and was on the verge of being destroyed by Three K'Vort class Battlecruisers.
Canon 1st - Ambassador - all finese, nice curves 2nd - Constitution Refit - back to the basics 3rd - Defiant - kick a**, sleek and fast Uncanon 1st - Century - best ship in the fleet 2nd - Vivace - excellent Intrepid take two 3rd - Excalibur - looks awesome, but a little weak