Although you mentioned not really liking most Zombie Apocalypse games, one I haven't seen recommended yet is State of Decay 2.

Several maps to choose from, also with the option of roads that can take you to any of the other maps once you tire of your first map choice, multi-player available (Up to 4 player co-op), has a side game of surviving waves of zombies, find other communities (NPC's) to join and build up a base camp, or kill for their supplies, and several types of super zombies.