I don't think the trope is doomed to triteness. The key thing is for the dream to effect a change. Just because things aren't real doesn't mean they don't matter. All ideas aren't real. Ideology isn't real. They still affect people. I've certainly had a few dreams that for one reason or another have really stuck with me.
For a game, I think the thing to do is to show how your actions in the dream have influenced the character upon awakening. Different choices change how the dream affects the character. If the dreamer is a dreary salaryman, perhaps being heroic in their dream is the catalyst they need to quit their job and make a go at their preferred career. Or, if you wanted to do a twist, being heroic makes them feel self-righteous, and they stay complacent at their dead-end life. Maybe it's being a renegade in the dream that moves them to overthrow the status quo.
Or becoming an ax murderer.
I feel like there's a lot of potential in using dreams to examine the psychology of a character, so the trope isn't irredeemable. It certainly is used very cheaply just about all the time, but it doesn't have to be.
For a game, I think the thing to do is to show how your actions in the dream have influenced the character upon awakening. Different choices change how the dream affects the character. If the dreamer is a dreary salaryman, perhaps being heroic in their dream is the catalyst they need to quit their job and make a go at their preferred career. Or, if you wanted to do a twist, being heroic makes them feel self-righteous, and they stay complacent at their dead-end life. Maybe it's being a renegade in the dream that moves them to overthrow the status quo.
Or becoming an ax murderer.
I feel like there's a lot of potential in using dreams to examine the psychology of a character, so the trope isn't irredeemable. It certainly is used very cheaply just about all the time, but it doesn't have to be.