Second, there's the support ships which fight off small ships to prevent the damage dealers from getting swarmed and distract larger ships. Destroyers don't fill any of these roles very well.
I find they work fine as escorts to fight off the small ships to prevent the damage dealers from getting swarmed, and distract larger ships. Now I find an Enforcer tends to be a better escort than distractor, but the Medusa can do the later quite well (although perhaps not as good as a close escort, sacrificing its mobility due to escort AI). Linked Sabots + Harpoons with an Expanded Missile Rack plus Missile Specialization officer on an Enforcer will wipe the first few frigates that get close, while also outranging or at least matching the range of any beam frigates.
- most damage bonuses against them
- least damage bonuses against others
These are a bit of an exaggeration.
Target Analysis is only a +10% bonus against destroyers, compared to +15% vs cruisers or +20% vs capitals. So clearly not the most damage bonuses against them.
S-mod Advanced Gyros provides a larger bonus against frigates than destroyers.
Wolfpack Tactics gives frigates the same 20% bonus against capitals and cruisers as it does destroyers.
And Wolfpack Tactics is also a +10% damage for a destroyer against cruisers and capitals that cruisers and capitals cannot get. So they don't have the least damage bonuses against others.
They really get the middle of road bonuses, rather than most and least.
As far as premium frigates that cost as much a light cruiser go, I actually prefer Medusa over Hyperion in 0.96. With Safety Overrides or without (although without SO I tend to take advantage of Tesseract weapon drops). Same maximum flux stats and shield stats, but more OP, PPT, and mounts, plus a ship movement system that is comparable. You can get 360 shields now with it as well. And all for 80% of the DP. It might not compare to a heavy cruiser, but a Medusa is a solid competitor to a light cruiser when fit with an appropriate officer.
I certainly have used Medusa in double Ordo fights. Might get unlucky and have one pop, but they definitely feel more durable than frigates in the same roles. Given the attached screen shot is from a Neural Link + Automated ship character build, those Medusa are doing quite well for only having Wolfpack Tactics and Crew Training from the leadership tree, and not using safety overrides. Systems Expertise + Phase skimmer + Helmsmanship (+50% maneuverability to get moving in the right direction faster) lets them back out from Novas and Brilliants most of the time.
Admittedly, not as strong as having, say, a pack of Gryphon cruisers, but I'd say it compares favorably against swapping in 4 Hyperions for the 5 Medusa (25% of the fleet DP).