TMP through TNG era designs are great.
One might go as far to say, GOAT.
Nothing else looks as elegant as Star Trek ships.
Doesn't matter if it was purpose built or kitbashed for the background.

TOS era look way too much like props.
ENT suffers from prequel constraints
Don't even bring up the atrocities of JewJew's Trek.

I got into Star Trek because of the ship designs that I first saw in Armada 2, the way Romulans got presented in the tutorial sold me on checking out the actual show.
The fact that it was Lower Decks that brought back the clean TNG look says everything there is about the absolute state of the franchise.