I'd hold on Cyberpunk. There will undoubtedly be a bundled/discounted version of it when Phantom Liberty comes out in September.
As a counter offer, may I present Control? One of the best action games I've played in decades that also has a really interesting story (if you like trippy Twin Peaks/X-Files style stories) and it's only $10USD currently in the sale. Runs pretty well on the Deck, and if you have a beefy PC to play on as well, has some really great RTX features.
The only other game that really fits your criteria that I would recommend is Hades which has already been mentioned. I put over 300 hours into Hades across PC and Switch (pre Steam Deck), and it's one of the only roguelike games that has a super compelling story.