Similar depictions occur in fiction, most of which are fairly shallowly-disguised Western, Journey, or Empire sagas relocated in space, though without any actual foundations on physics. Hard science fiction can sometimes make a few nods to reality, and often exists as a sort of "what if", exploring the potential consequences of some scientific or technological capability being realised, but again has very little basis in any known physics.
And I write this as someone who was caught hook, line, and sinker by the von Braun vision of spaceships to the planets, Asimov, Clarke, Heinlein, and others. As I've gotten older it's the psychological and social explorations which are more interesting: Le Guin, Stephenson (who tends to remain in near-Earth orbits), Bradbury, Butler, KSR, and the like.
Not that the fantasy isn't still attractive at times, and with the capabilities for visualising potential space-scapes and starscapes, the visual imagery really is stunning, as in 1RPM here.
(I'd watched before reading the description, and pretty much all the points Wernquist highlighted were ones I'd noted in the video itself.)
