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.