Risa

Oh agreed but I think there's one major thing which is what really fucks up how your perceive it. There's nothing to compare it to.

When we see the ship it's typically just by itself flying through space where there's no comparison. Or it happens across a ship but same problem as the Enterprise so no reliable comparison. Orbiting a planet, surveying an asteroid, being yanked into a Pulsar, sitting in front of a Borg cube... All of these huge events have literally nothing reliable that humans are familiar with to compare it to. The closest you can say are the windows but the windows are such strange sizes for what we're used to that it doesn't help much.

Honestly the biggest 'events' that I can think of in Trek media that demonstrate the size of the ship are usually ones where the ship ends up on a planet. Generations crash land, Into Darkness crashland, Voyagers Blue Alert sequences, Discoverys crash land, etc. The only other one I can think of is from Picard Season 3. The Borg cube in Jupiters eye. That thing is fucking massive and the cube took up an enormous amount of space in it. That really shook the hell out of me in seeing how big that vessel was.