It made more of an impact on my latest playthrough, mind, and that's because of the aftermath of that final battle. Meet a shady character near Skull Hollow, chat for a bit, and then head deep inside the catacombs of the Bone Gallery to fight Mordrox, a giant zombie troll. It's a side-quest tucked snugly into the game's first act, and it's typically pulpy stuff.
I didn't really notice Bring Out Your Dead on my first few playthroughs of Torchlight 2.