Like many people, I enjoyed looking into the background scenes of First Contact/the Dominion War/isolated Voyager episodes and spotting the Akira Class, thinking it looked pretty cool (tho personally the steamrunner was my out and out fav of those background ships )
Then perhaps like a lot of people I felt exploited that the producers used that popularity to base their new ship on the Akira, all the while ruining the design by changing what made the ship unique.
Nah, never took to the NX-01, Voyager too looked like a stupid upturned spoon....but most other Trek ships look great.
(except the Oberth...don't know what THAT'S about! )
The Enterprise-E and the Defiant are my out and out favs. Since you didn't ask.