Overall, I gotta say that the intrepid class is the goat. Separate the saucer? Fuck you, we're going to land on this rock with our fucking landers without leaving a DBZ trail behind. The enterprise has ChatGPT 18.5 turbo, but you can't fit that into the energy requirements of a ship like Voyager, so the designers of the intrepid class did a line of space coke, hit their head on the table on the way down, then got up and got ChatGPT 19 to run on roided out bundles of mouse neurons. Tired of squishy human doctors? Us too, man; here, have an EMH, never turn him off, maybe he'll get superpowers. Or hologram dementia. Or both? Idk, he's sassy and overpowered, you're going to love it. Check it out, dawg, the fucking nacelles move! The bridge looks sick AF, too.
But I also really like the Cali class ships from lower decks as a representation of what the more mundane day-job ships in the fleet are like. It's nice to see these roles explored, and the design of the Cali class tends to reflect its role: nothing fancy, it's practical and straightforward without being austere.
Enterprise E for me. I understand this is controversial. I really like the Intrepid class and I think the Runabout and Defiant are under appreciated as well.
I'll always prefer the look of the Constitution variants, from the original up to the Sovereign. I like many other styles too, but no other ship profile is more recognizable, even by non-Trekkies.
I wish the Enterprise-E followed this design trend, instead of the stretched out, spindlely nacelle looking like they'd snap at the first hard maneuver garbage we got instead.