I'm not sure those attributes would necessarily make the ships special.

I mean, surely Starfleet would build every starship class to be the most advanced ever? Surely all of them would be designed for deep space tactical missions? And surely none of them would be designed for musical performance?

Timo Saloniemi

of course not, ex :ships like the Nova are designed for short range planetary research stated on screen not long range tactical missions.
not every ship was designed for the same things but in the Dominion war all ships were used because they were desperate.