Tbh there isn't a single ship that is good for everything. The Spire requires a good teammate to keep brawlers off you, and a good engineer to keep your hull and guns up. I'll be honest when I play against a team with a Spire I'll be focussing on that, especially if I'm in a Pyra, because when isolated from their team mates they are easy kills.
Generally speaking ships have layouts which make them easier or harder to 'get' for new crew, listing them in order of difficulty (according to me) -
Goldfish, Pyramidion - guns on the front, vital components in 2 clear zones, though accessible in a hurry.
Junker, Galleon guns on either side, upper and lower deck physically separated, components collected in 3 zones.
Squid linear layout, but all 4 engines need to be prioritised with the hull and balloon.
Spire gun mounts all over the place, three decks physically separated, main gun and vital components spread over the other all 3. Mobula 5 front facing gun mounts with off centred alignments, vital components physically isolated from each other and awkward to get out of in a hurry massive rear blind spots.
I'll move up or down the list depending how well things work out on board ship during a match.
My favourite ship is the squid, it's just fun to fly, next comes the Mobula