A good co-op night has less to do with the game than with the table.
Pick the right game for the table
Co-op RPGs differ in pacing. Baldur's Gate 3 and Divinity: Original Sin 2 let four players act at their own speed; Monster Hunter Wilds and Nightreign want everyone in the same fight. Pick one that matches how much your group likes to talk.
Set expectations at session zero
Before the first quest, agree on play time, how loot is shared and what happens if someone misses a night. Ten minutes here saves arguments later.
The best sessions end with everyone asking when the next one is.
Book the same seats every week
Guild tables can be held on a weekly slot. Same seats, same screen, same snacks, and nobody has to rebuild a save on a different PC.
End on a cliffhanger
Stop just after something big happens, not in the middle of a dungeon. Everyone comes back next week.