> Do you really think a PS5 game will be that much more enjoyable than a PS2 game
Can be, absolutely.
I played Read Dead Redemption 2 last year. There's a wild west cowboy outlaw game in there somewhere with a storyline that you can finish, but what completely blew my mind is how stunningly beautiful it is, how beautiful the world you're riding around in is, and how ugly human encroachment on nature is. Because as time progresses in the game, the frontier moves a little bit further, more trees are felled, more clearings made, more houses built, more railway tracks are laid, more humans, more civilization, more stinking cities.
You absolutely could not make a game like that on a PS2. You need a 4K screen and hi-res textures and HDR lighting to really make the world pretty, to really make you care about that world.
I played Zelda: Breath of the Wild on the Switch as well. It's also an open-world game, and because it has infinite draw distance, they've managed to craft a world where no matter where you stand, you can see something interesting in the distance. I have never played a game that made me be so excited to explore and to get sidetracked as that game. The actual gameplay is also expertly bite-sized, so it doesn't matter if you play for 15 minutes or 15 hours, you still have the same sense of progression.
You absolutely could not make a game like that on a GameCube. You need hardware enough to do a seamless open world with infinite draw distance and no loading screens, otherwise the experience just doesn't work, just wouldn't be able to show you all it has to offer all at once.