Nothing wrong with going back to the single player after the ending in my own opinion. But Undead Nightmare will be fun, besides zombies there are also zombie animals and mythical creatures.
I played multiplayer a day or two ago (it works again for me!), was instantly asked to join a posse then defend and hold that Mexican fortress, and I did a great job at that, especially after I picked up a Buffalo rifle off someone's corpse.