Your characters don't need to be tragic to be valid. Sometimes the most futuristic thing you can write is a happy ending.
I love an O’Neill Cylinder as much as the next guy, but if your characters are just tour guides for your world-building, your reader is going to DNF.