It Takes Two was fun time with 2 people. The story is a little corny but overall enjoyable.

If you’re into mmo, Old Republic have most story, and it’s even quite good.

What’s a story game ?

Alice is missing is a Silent, one shot narrative rpg and would my go to recommendation for casual players

Secrets of Grindea and Dysmantle. I’m sure I’ll come up with a lot more, I go deep diving all the time for games for my partner and me

Secrets of Grindea - Tongue in cheek, Secret of Mana inspired ARPG. They recently finished the story, and there is also an arcade mode that is a blast with friends

Dysmantle - Survival Crafting Lite where everything is destructible. We REALLY enjoyed this one. I’ve downloaded it again for us to play through a second time. One of the DLCs is mediocre, but the other two were fantastic. I still enjoyed all three

Edit: I don’t think I saw anyone mention Outward. A difficult, medieval action RPG

Edit 2: this may be too light on story, but Cat Quest 2 and probably 3 (I haven’t played it yet). Cozy ARPG Lite. We liked it a lot