This is one of those videos that builds slowly and then starts to wheel in the surprises. Star Trek, Halo, Mass Effect and EVE Online dominate towards the end but we’ve also got V, The Dark Zone, Warhammer, Star Trek and others in here.
I’m reminded of the very impressive sci-fi spaceship comparison chart by Dirk Loechel. If you like the video I’d recommend checking out this poster image too. An alternative is this old How big would the sun look? which is rather helpful when designing game worlds.