"Ugly" is subjective, but "lower tech" is fairly in-your-face whether you compare the DSC Enterprise to the other DSC interiors, or the TOS ship to the DSC ones.
Or is that higher tech? It's the look of the future, after all, with push-buttons but no holograms in all the 2280s starships we get to see. Either way, NCC-1701 is different. And we can't seriously claim it's the only way to put together a starship now. So it's either cutting edge or past news, and basically everything in the stories speaks for the latter, giving the ship history.
Also, serial and indeed habitual refitting would seem more apt for a ship that is breaking apart at the seams than for something that just floated out of the construction dock. Unless we think NCC-1701 was something of a Monday specimen, built all wrong to begin with.
In any case, dialogue painting Kirk's ship as the most modern thing out there is completely missing. Dialogue painting her as superior to her colleagues is also absent, although back in the 1960s we could still argue whether this was because there were no other types of starship in existence at all, or because this particular type did not outshine the bountiful competition enough to warrant mention. Nowadays we must accept the latter.
That a starship trumps other types of ship isn't a vote in favor of the Constitution class specifically, and hasn't been since Kirk declared the old Archon "starship", too.
But yes, more Hornblower is good. Although I do have a soft spot for WWI era ships fighting on in the 1940s. I mean, most of the heavyweights were of that sort anyway.
Timo Saloniemi