Well, I suppose a ship that is called a Generational ship, is gonna be humungous. It could be the size of a Borg cube or Babylon 5 for all I know. Just don't know if it counts since we have no official stats on it, and we never saw anything other than a blurry pics, nor next to any other ship for a frame of reference.