My first command was HMS Bellerophon.
I've always thought the 74 to be big enough to have that majestic feel. In SGN (and several other age of sail games) they are still maneuverable enough to be fun to sail. Frigates have a romantic "alone in the world", "hero captain" feel to them but I love the battle lines of ships of the line.