Personally I’m really obsessed with the lore in Fire Emblem: Three Houses
deleted by creator
I really love Jack Vance’s world building. His Gaean Reach setting gives an endless variety of cultures, customs and beliefs. And the Dying Earth novels formed the basis for magic system of DnD.
But the real treasure is in how he can let these worlds come alive with his descriptions. Often he would spend a whole paragraph describing something that will never be part of the story but manages to perfectly set the tone of the local atmosphere.
I grew with these books (thanks to my dad’s impressive personal SF library) and they’ve always managed to spark my imagination like no other book.
Kim Stanley Robinson’s Mars series.
Just a breathtaking setting that begins with the first hundred settlers and traces the intrigue, terraforming, conflicts, and dreams of the colonists. It’s a sweeping epic written on a human scale.
The Elder Scrolls is probably the one I’ve had the most fun theory-crafting about, but I will admit that you have to pick and choose what to care about.
Also the old Wipeout racing games had a remarkable amount of background plot going on that was really pretty fun. The self-awareness to poke fun at Fusion’s poorly-received changes as being the in-universe result of megacorp meddling for mass market appeal gave me a good laugh, but you can piece together a surprising amount of the world from random references in team flavour text
The Expanse or First Law
I’ve never heard of First Law, but it being mentioned alongside the Expanse is reason enough for me to check it out
LotR - it’s really fucking hard to top especially when Tolkien was pioneering the field.
Dune is incredibly unique. Scifi without computers and genetic magic. All politics. The books are outstanding.
Caves of Qud was my first contact with post post-apocalypse. Can’t even begin to convey how strange and magical everything feels in that universe.
The latter books are just weird with all the sexual imprinting and other weirdness which sounds more like written by a horny teenager than an adult.
Call me boring but Randland (The Wheel of Time).
His Dark Materials is worldbuilt very well, I also like ATLA for its worldbuilding, even if it’s a bit simplistic at times.
HDM for sure.
Final Fantasy Tactics Advance is really solid, if limited. Not sure how similar it is to the non-advance version.
Dragon Age, I really love the lore. Hopefully the new one won’t disappoint.
Also Wheel of Time has a really nice worldbuilding.
Right now I’m way down a Brandon Sanderson rabbit hole, so I guess the Cosmere? I’d say Stormlight Archive, but Mistborn is really cool because they’re set at the inflection points in the planet’s history. The first arc is excellent, and it changes the world. The second arc is set in the future, with mythologies based on the first arc and scientific progress based on secrets uncovered in the first. The changes in the use of magic are really cool. There’s a third arc planned to be set in the future from there.
But the Cosmere as a whole shares some core concepts and characters can move across it, and that comes into other standalone works like (3 of 4) secret projects and a bunch of other stuff.