The Excelsior-class is one of my favorites. A bit wonky from a top-down view, but gorgeous from every other angle.
The Sovereign-class continues the general aesthetic of the Excelsior, but for the TNG-era design style and fixing the problem with high angle views.
The Valdore-type warbird from Nemesis is probably the best thing about that movie.
The Klingon D4 from Into Darkness is similarly one of the better things from that movie.
The NX-class Refit is also just shockingly pretty. Makes the original look incomplete.
Not canon, but I love the original “Long-boi” Discovery design. It gives off some very cool art-deco retro-futurism vibes. Not very classically “trek” but I love it nonetheless!
That is the canon design for the Discovery before the far future refit it got.
It's like an RV, but with warp and replicators. What's not to like?