There's a good guide to missiles
here. Basically, heavy missiles are most effective against cruisers and lights against frigates. Of course, what skills you have in the various sizes will affect their damage output as well. I used to use heavies a lot as they can still do reasonable damage on frigates to battlecrusiers.