It's not strictly true that it didn't mean anything, but I would say that it consisted of a couple weakly-defined and often mutually incompatible visions is what could be.
Meta thought they could sell people on the idea of spending hundreds of dollars on specialized hardware to allow them to do real life things, but in a shitty Miiverse alternate reality where every activity was monetized to help Zuck buy the rest of the Hawaiian archipelago for himself.
Cryptobros thought the Metaverse was going to be a decentralized hyper-capitalist utopia where they could live their best lives driving digital Lambos and banging their harem of fawning VR catgirl hotties after they all made their billions selling links to JPEGs of cartoon monkeys to each other.
Everybody else conflated the decentralized part of the cryptobros' vision with the microtransactionalized walled garden of Meta's implementation, and then either saw dollar signs and scrambled to get a grift going, or ran off to write think pieces about a wholly-imaginary utopia or dystopia they saw arising from that unholy amalgamation.
In reality, Meta couldn't offer a compelling alternative to real life, and the cryptobros didn't have the funds or talent to actually make their Snow Crash fever dream a reality, so for now the VR future remains firmly the domain of VRChat enthusiasts, hardcore flight simmers, and niche technical applications.
You've already had a recommondation for most of what I would suggest to you, but I will happily second the suggestions for the Revelation Space series by Alastair Reynolds, the Teixcalaan series by Arkady Martine, and the Imperial Raadch/Ancillary series by Ann Leckie. All have excellent worldbuilding and tell stories that depend heavily upon how their characters interface with the worlds they inhabit.
A little pulpier in tone, but still very well put together, I'd suggest as well the Wayfarers series by Becky Chambers, and especially the Locked Tomb series by Tamsyn Muir. The latter is a bit more fantastic space opera as opposed to some of the harder sci-fi you've mentioned, but Muir knows how to write a setting that is absolutely dripping in gothic horror, and still take you on an emotional roller coaster fully of highs, lows, and humor as you read it. It seems to be a bit of a love-it-or-hate-it series from the other conversations I've had about it, but I love it and I'd be remiss not to suggest it.
I'd also suggest, if you're not averse, dipping your toe into the fantasy genre as well. There's a broad range of authors there who have done excellent work building fantasy worlds that are structurally deep and compelling, and have many science-fictional qualities. Along these lines I'd suggest Robert Jackson Bennett's Founders trilogy, or N. K. Jemison's Broken Earth trilogy -- though, fair warning, both of these broke me in the end emotionally. Worth it, though!