Some more story co-op games to add: Guacamelee (co-op metroidvania), any of the Lego games, Trine

Also, Divinity Original Sin 2, Towerfall Ascension, Giana Sisters, XCOM, Sniper Elite (enjoyed single player, and it has a coop mode that I've never tried).