Black House by Stephen King and Peter Straub

With his beloved town visited by supernatural evil, an earlily-retired detective with uncanny skills is brought back to life. And then killed. And then re-animated. And then the sequel...

When not waving hands around, King / Straub can still draw you into their world. Too bad he's not yet written a "Midwinter's Night Scream" or something with more depth than allusions.