You've probably already read Death Gate Cycle (and if you haven't, why not?), so I'll have to back up the Forgotten Realms recommendation, namely R.A. Salvatore's work. Some of the books are blatantly better than others, but Drizzt is by far one of the best characters I've already read. (Although there's not a lot of sex in the early Drizzt books... but that changes later on).

Sword of Truth seems to be exactly what you're looking for, but I can't exactly recommend it personally since I haven't read much of the series yet. I'll probably do that after I finish The Da Vinci Code, which will likely happen later tonight.