Honestly, it was always Picard's Enterprise (D I think...?) from TNG.
I always really liked that take on a capital ship. They're usually military vessels or logistics craft, what else do you need something that big for? The Enterprise was well-rounded though, and perfect for deep space serial adventures around more complex moral and ethical issues.