An example is GTAV. Where there are lots of structured things to do yet the players constantly make their own meetups, car shows and other shenanigans.
A notable exception could be Minecraft, where you could have your own single player world and so long as you are interested it can keep evolving.
That is true, and that alone would make the necessary development not economically viable for any game whose life is measured in few years, but what if, along content provided by players, the game creators could insert new environments with NPCs and new stories without ditching the game? In a few years/decades probably AI could also generate characters that develop themselves according to the environment they "grew" into or events happened during their "life". Dreaming too much maybe:)
This is also true for the other examples (Minecraft and No Man's Sky) where the games basically become what the player base uses it for. I think this happens to most freeform games where without the multiplayer aspect, the game basically is nowhere near the same experience as with.