I enjoyed Needful Things narrated by him, don't think The Stand I listened to was by him though. I do agree On Writing is a good choice by him, helps it's about King too. Of course Needful Things starts with a couple of Maine old timers sounding like they're talking on a porch which his accent conveys very well. The first narrator for the Dark Tower series did Roland perfectly, was more difficult when they had to switch and definitely wouldn't want King instead, though it'd almost make sense if you know the story.

I agree there's definitely a few books I've stopped listening to because I didn't like the narration style or voice.