I hate to be the dream-squasher here but the technology will quite literally never get there. You’re thinking along the same lines as Back to the future where 2015 is filled with flying cars and sky-highways.

Until there's an AGI that won't happen in any meaningful way. Why? Because here's something that matches your criteria of:

a mystery detective RPG in the style of Sherlock Holmes but set on a cyberpunk styled city on a space station like the Citadel from Mass Effect

You get a text based game where everything you try to do ends up with you dead because a corporation kills you unless you discover that if you look at the ground where you start there's a penny from the year the murderer is from, and then you need to discover who's the murder (changes every time) based solely on this, because that's the sort of thing Sherlock Holmes would do. No, it's not fun, it's frustrating, it's essentially luck, if that's fun to you I have an infinitely replay able game, flip a coin and see how many times you can get heads in a row, if you get to 16 you win.

The thing is LLMs don't understand "fun", they're just auto-completes, so they will just do boring or unfair stuff. And you would need to go very deep into the specifics of your game, to the point where you're essentially programming the game, so at the end of the day it's not something an end user would use.

That's not to say there aren't interesting uses for it inside games, but the moment you can prompt an entire game that's actually fun to play on an AI, that same AI would be able to replace almost every job in the world.

I honestly disagree. The things you're asking for contain meaning. They require an ability to grasp arbitrary levels of context. There is no way to grasp that level of context without encountering yourself within that broader context and becoming self-aware.

At that point, you might have a system that can do the things you're describing, but it would be a person. That's not really automation as much as it is birthing a brand new kind of intelligence, and it may not consent to being your servant, and it would not only be wrong to try to force it, it would be extremely dangerous.

I think for that reason there is a hard limit on automation. Some tasks are the exclusive domain of personhood, not automata.

I'm curious to know what happens if you ask ChatGPT to make you a text adventure based on that prompt.

Not curious enough to try it and play it myself, though.

Just be careful about asking it to create villains capable of outwitting you.

When the technology gets there, this will be amazing. I’ll be able to sit down at the computer and say “make me a mystery detective RPG in the style of Sherlock Holmes but set on a cyberpunk styled city on a space station like the Citadel from Mass Effect” and I’ll get just that, generated exclusively for me with a brand new story that fits the themes I asked for.

And you'll pay $200 for it.