Well I haven't flown many other ships so I can't really compare.
But I can say what I think: it's agile and fun to fly, and does it's job decent for solo play. I can't tank in it much, but I use to "hit and run" attack and let the hangar fighters do their job. You need to be atleast half awake to fly this ship.. Also I think it's the best (or second best) looking ship in-game.
---> Anti nerfcriers disclaimer: The Vesta is too weak and needs a huge powerboost. <---
All of the end-game Escorts are good, it just depends on what exactly you're looking for. Personally, I swear by my Steamrunner. It doesn't put out as much damage as some others, but if you set it up right it's virtually indestructible, especially with an Engineering Captain. The only issue I have with it is I would REALLY like more Science abilities (The only Sci. Boff station is an Ensign, but other than that it's a lot of fun.