I don't think that simulating the vastness of the universe is ever going to be fun, but approximating a theme park ride that evokes the vastness of the universe can be breathtaking, like Outer Wilds was. (The gameplay is confined to a single solar system, but it certainly makes you feel both the a sense of adventure, and the vastness of space-time.)