I hate Duchovney and never got Californication.
Dexter is pretty much my tops all-time. That first season was near perfection, and just about beats out season 1 of Twin Peaks. The second season surprised me in the way it was able to continue in a very different vein. There were some holes in some of the scripts, but it was still great, where Twin Peaks really tailed-off already in the second season.
I love the way it makes the viewer somewhat complicit in the stuff Dexter does, and really does some mind-bending stuff around the idea of evil - a very Lynchian sort of thing. I suspect in season 3, that Dex will become recognizable as a normal, non-psychotic human, and will have to reconcile that with his past.