I think what my ideal is basically DnD, but with an AI DM.

This is something that I'm hoping the current LLM and future AI work eventually get us to. If we can get persistent context and memory, or at least a simulacrum of that, we could get to truly dynamic reactive worlds