WMG / Red Dead Redemption: Undead Nightmare

Seth is virtually in command of his own undead army.

It's demonstrated in the cutscenes that you see him in that the undead won't attack him. In fact, they seem to do whatever he wants them to do, and don't object to dancing or playing cards. Now at the end of the story, Seth steals the mask that causes the Zombie Apocalypse. By being in possession of the only thing that can stop the apocalypse and being immune to zombie attacks, basically nobody can stop him. Except for maybe the only zombie with a soul...

John Marston is now Death, and War, and Famine, and Pestilence

Upon crawling out of the grave, Marston finds Death waiting for him. God has selected him to become the new Grim Reaper, the old one obviously not doing his job. Because he mastered the other horses of the apocalypse, who were let loose to select new bringers of the end times as the old ones let it happen to early, he is now the Single Rider of the Apocalypse

Why John still dies at the end

In the WMG section of Red Dead Redemption there is a quite compelling theory of that the main storyline is book Jack Marston wrote of his father exploits, written so John looks like a good guy and most other fellows are... well idiots and complete assholes. The starnger quest are not a part of the book and are things that happens outside the books story, since Jack can finish them and when you kill Ross it is not an official mission. That being said, the same goes for undead nightmare, being a completely fictional story Jack might have inspiration from the book his is reading in the begin.

So why do John still dies at the end when Jack could easily just have made up a happily ever after story. Because Jack hates Ross to death. What would magnificent asshole do when you should focus on rebuilding society? He goes after the guy have meant to kill but where unable to because of a very inconvenient apocalypse, but when that was over he had his chance. Didn't need to kill him, he could easily have said John died during the undead plague but no sir he wanted John dead for real. Or at least so Jack portrays Ross in his books, like an evil asshole that just look out after himself.

John is in Hell.
The game actually takes place fully after Redemption, in which John is killed, and the events that occur here are his damnation. John's goal throughout the first game was to leave his violent past as a gunman behind, and live a peaceful life as a rancher with his family. So what better way to punish him than this?

His family is once again taken away from him, he must once again kill people by the score, and in the end he once again dies only to rise up as an undead monstrosity and stalk the world; he can never escape his violent existence, even in death. The fact that he's in hell is why supernatural elements like the Four Horses and sasquatches now exist. In fact, the mission with the sasquatches is a perfect example of the universe confronting him with his sins in a What the Hell, Hero? moment; he kills others simply because he was told to, without seeking an alternative or stopping to consider whether it is really necessary. John's life in a nutshell.

Why was the Double-Barrel Shotgun in the Barn?
The Shotgun was in the barn because it needed some minor repairs. Or, perhaps John was cleaning it up so that he could give it to Jack as a Birthday Present, or some such thing. In the main game, just before John's Final Battle, he talks to Jack about perhaps taking him quail hunting. A double-barrel shotgun is fairly easy to operate, easy to load, and easy to maintain, and thus is perfect for first-time hunters, and since Jack is a rookie hunter at the time, this would have been a good weapon for him to use while hunting birds. Shame it had to be used on Uncle.

Why didn't John use his Revolver instead?
Simple reason, it wasn't loaded. Alternatively, given how aggressive Uncle was acting, it might have been more dangerous to go for the revolver than to run out to the barn, where John, for one reason or another, kept some shells nearby for the shotgun. Also, it's possible that John was just going to use the shotgun to bring Uncle back to his senses, thinking him drunk, and not actually intending to blow his head off, until he realized what was really happening to Uncle. Alternatively, it's possible that John thought that his wife would head into their son's room for safety, and not run outside, where she later tripped, got bitten, turned, bit Jack, causing them to get tied up.
http://tvtropes.org/pmwiki/pmwiki.php/WMG/RedDeadRedemptionUndeadNightmare