I felt the need for a bit of analysis so I did this. I included any ship that I thought was being written/portrayed, not necessarily that it was successfully done. I left out any that weren't obvious or I can't remember. Editing is encouraged. Disagreement is welcome.
Spoiler:
Comment