. . . I actually wouldn't mind using real-life locations like that - but with added set extensions - CGI and real - that cover up the obvious down-to-Earth looking bits, and that add some futuristic looking starship engine/engineering parts to the location sets.
Like this shot from the 1970s Buck Rogers
TV series that combines the Bonaventure Hotel in downtown Los Angeles with a matte painting. Still looks pretty cool if you ask me.
Absolutely, that scene from Buck Rogers In The 25th Century 1979-81 series "Awakening" pilot episode that was first released theatrically in 1979 still looks great.