I feel I should point out, with all this talk of "sinking ships", that it is mostly unnecessary to sink a single ship. All you need to do is spoil their mission

I feel I should point out, with all this talk of "sinking ships", that it is mostly unnecessary to sink a single ship. All you need to do is spoil their mission capability. This could be as simple as a fragmentation munition peppering the radar or other critical system with shrapnel (which can be targeted specifically). A $50 munition on a $500 drone damages the $50m radar on your $500m vessel, and now you are out of the fight until a repair which will 1 year. Someone with more domain expertise, feel free to adjust those numbers.