sorry i don't know enough about multiplayer or local multiplayer games although if you're looking for a Co-op game i would recommend It Takes Two. it's simple but has its own charm. beware it's a third person game and has some shooting sections in it but it's beginner friendly enough.
i think city builders and management/tycoon games would be great for these situations cause if you like them there's no upper limit on playtime. cities skyline and RollerCoaster Tycoon are both great. if you're looking for something like factorio satisfactory could also work.
of course adventure games or puzzle games are also a great fit since most of them tend to have simple controls but great story and humor and hard puzzles that can keep you busy while solving them is satisfying. i've made a post recently on this community asking for people's recommendations so definitely check that out.
there's also this lovely little game called Townscaper. it's really simple you just add or remove blocks on a non-rectangular grid on a sea and the game tries to generate a pleasant looking town. it might sound lackluster on paper but it's fun and you can get some hours out of it developing your town and discovering the town style rules (there is also some hidden structures that can pop up discovering those is also fun).