As I understand it, Radiant AI is a framework for fixed and relatively simple finite state machines, with states like "use the anvil at the blacksmith's shop during working hours" or "drink in the tavern at 9 PM." Don't get me wrong, it's leaps and bounds beyond the NPC AI found in earlier games, but it's far from the emergent craziness you'll see in a sandbox game like Rimworld or Dwarf Fortress. Dynamic behaviors like the one you mentioned are still all essentially scripted interactions. Dialogue, the core interaction between the player and most NPCs, is still 100% scripted conversation trees. The most interesting emergent events I remember from Skyrim (or Oblivion) were funny glitches like this one:
https://www.youtube.com/watch?v=QvuW2Jl5ZyY
I'd also like to hear the GP commentor's reply re: emergent gameplay in Morrowind. I haven't played that game as much as the others, and don't have enough in-game experience to comment.