This is a video created by MetalBallStudios (in my mind they're a pinball!) comparing the sizes of different ships in the Star Trek universe. Not every ship in the Star Trek universe though, "only the most important." I learned a lot by watching it. Mostly, that nobody ever bothered painting their spaceships. Come on, everything's the same boring grey. I get that you're in space where it's dark but I would have at least painted some flames on the side or something. Not even a single 'If You Can Read This My Tractor Beam Is Working' or 'Honk If You're Horny' decal? Aliens are lame.
Keep going for the video.
Thanks to gib, who agrees it's not the size of your ship that matters, it's how you rock that boat.