I ran Demon God's Fane and we really enjoyed it.
We lost 3 PCs out of 6 through the adventure, all in different battles. At least 2 of those deaths were player stupidity though.
SPOILER: I love the time travel bit at the end, with the PCs returning to a slightly different world, because of the battle they fought in the past. I made good use of that to change a few important (to the campaign) things about the campaign world, and confused the heck out of my PCs in the process. Good times! The glabrezu fight is also very cool- he threw a PC through a prismatic wall in my game, which really shocked the players cause I'm not often that evil to their characters. <g>