Yeah, I think at most very literal titles would be a stylistic phase. Even "The Martian" is more a play on words than just a literal title for what it's about.
Taking favourite novels which are within arm's reach: Sure "Rainbows End" is Science Fiction which doesn't involve space travel etc. but "Incandescence" is also SF but that's deeply about space travel. Banks' "Whit" and "Surface Detail" are both sat here. One of those is set in a lightly fictionalized Scotland and the other is a Science Fiction novel where the main protagonist dies but is resurrected, then is witness to several of the most significant space battles of her era. But like, if you didn't know, how would you guess which is which?
Now, Banks wasn't a hard SF writer. Unlike say Egan's "Incandescence" none of the events of his SF novels are actually physically plausible, but presumably this list is about genre SF and thus includes Banks, Bujold etc.
A bit of an off-topic observation:
Banks might not have focused on the hard sci-fi aspects but I have a difficult time imagining a more likely future for humanity than something like the culture civilization.
As cynic I would imagine eventual collapse to be more likely. Probably slow degradation back to some sort of semi-advanced agricultural society. Say kinda post-apocalyptic world(without proper apocalypse) with larger societal structures still existing. Slow degradation of industrial output until some balance level is reached.
Probably not best sci-fi universe one can come up to. Or most selling one.
"The future is socialism or barbarism" (Rosa Luxemburg). I fear we have chosen the latter.
The Culture can't happen. It requires Faster Than Light spaceships and that's not a thing in our universe. Also, and I know it's not what you meant, but in Banks' fiction "State of the Art" is specifically a novella about a Culture visit to Earth in the 1970s. They're not us.
Egan's "The Amalgam" is an SF society which could in principle descend in part from some future humanity, and I suppose if you like Banks' setting for its utopianism you'd be satisfied with the Amalgam. Its citizens tend to live long, full lives in which they're definitely mostly concerned with the upper parts of Maslow's pyramid and their practical needs are fulfilled as a matter of course in most cases.
I must say, to the extent we have any future at all, I think probably of Egan's "Dream Apes". An Orangutan-like self-engineered future humanity who have arranged that there are no apex predators above them, there's an abundance of resources for their relatively modest population, and they just chill, believing that if there is something out there it's not their concern. Of course in the story the Dream Apes are all annihilated by a cataclysmic event which destroys Earth, but hey, it's pretty quick.
The part where superintelligent computers keep humans around as pets in a powerful and happy civilization is plausible. The part where there’s hyperdrive and energy grids and fields and effectors, less so.
IIRC Banks insisted in interviews that the culture's citizens aren't pets. The exact relationship is, like the FTL travel and indeed teleportation, very vague and only sketched in where needed to advance the plot.
We have no experience with the extremely asymmetrical relationships which would result. Lem tries to imagine this in Golem XIV - what happens when humans who are used to thinking of themselves as smart are talking with a categorically more intelligent machine - and it doesn't work very well even though it's only a sketch.
"Tatja Grimm's World" has a neat trick where Vinge is able to sidestep this because [[SPOILER]] although Tatja is much smarter than everybody else from her world, that's not because she's smarter than we are, almost everyone born on her planet is an idiot for reasons the story justifies.
so... it might be a marketing problem?
no publisher was there to tell author "wtf did you name it, you'll get ignored" or smth?
I don't think anyone's failing to recognize modern sci-fi novels because they aren't called "The Space Martians Go To The Moon In Their Starship" or whatever.
Really, I think the most significant trend here is that, between 1950 and 1980 or so, the sci-fi genre grew up and stopped relying on painfully literal titles.
Publishers make choices the author had no say in all the time. One of the things commonly mentioned about Phil Dick is that while the movies you've probably seen based on his work (such as "Blade Runner" and "Total Recall") have different titles than the stories they are based on, those stories weren't published under his proposed name in many cases either.