Unfortunately two things turned out to be true:
1) Most people don't want any of this and prefer to be on rails
2) The two groups of people most attracted to a game like this wind up in a dynamic where one group will leave the game if the other is present. Whereas the 2nd group requires the 1st to want to play.
This is also where I first started seeing people focusing on "end game", although it may have existed in EQ. The actual sandbox-ish game was just a warmup you blasted through in order to get to the "real game". Meanwhile I ran around solo and just explored, and did whatever weird thing I wanted.
Both groups self-identify as wanting a "real" experience in a sandbox that lets them "do anything". However one means this allows them to slaughter people with impunity whereas the other means it enables them to explore the world, choose their own occupation, define their own goals, etc. It's not even a PVP vs PVE divide, as there are plenty of PVPers in the 2nd group. Instead it's closer to "Griefers" vs "Sandbox game enthusiasts", where the griefer crowed requires prey to feed their urges.
So what happens is the griefer oriented crowd chases away the other crowd, then has no one to grief and then they leave too. You'll see it in comments here as many posters were, shall we say, not super mature 25+ years ago :) they'll be pining for the days about how they could kill everyone, steal their stuff, loot their houses, and otherwise cause problems.
One of the issues with the game was that while those behaviors were intentionally allowed, the designers didn't account for the kind of player who *only* wanted to do that and generally were obnoxious about it to boot instead of trying to massage it into the lore/RP of the game. So the scale was all off.
1) Asheron's Call (which had a very active mod scene and now an emulator scene). I don' think the servers are nearly as popular as UO though.
2) Shadowbane (this one was heavily guild based but it was fun being a bit of an outlaw and PvPing random people and guilds).
What about
- Star Wars: The Old Republic (SWTOR),
- The Elder Scrolls Online (ESO),
- Guild Wars 2 (GW2),
- EVE Online,
- Black Desert?