how it's working for readers who aren't me.

You enjoy it despite the over-the-top angst, and others enjoy it because of the over-the-top angst?

Incidentally, I like the books despite never much liking Lymond: I was interested in him. I cared what happened to him. But I didn't find him likable. (I did like some of the supporting characters, a lot.)

Conclusion: the books work on a couple different levels, and may be enjoyed by different readers for completely different reasons.