I think it would be perfectly possible to make the Connie work. Many of those fan recreations show how it could be done, and they don't have the budget of a TVshow to work with. Basically just use the basic TOS Connie shape and colours, add TMP levels of surface detailing and it would look fine (maybe give the secondary hull some of that TMP style curvature, IIRC Jefferies wanted to do it that way from the get go, but it was too difficult to model.)
And of course if it is not Enterprise but some other Connie, there is even more leeway.
I don't know why so many people resist this. The original 60's aesthetic was a massive part of why the show was popular, why do you think so many fans have either built their own replicas or even gone so far as to rescue the old stage pieces and restore them?
Just take the original design and give it a higher budget. Smooth off some of the sharp corners here and there, but leave the red railing and the multi-colored displays.
As somebody else said, we have three good reasons the classic look works with modern Trek (Relics, Trials and Tribble-ations and In a Mirror, Darkly). (And VOY's Flashback did movie era tech and it still looked good too).