Red Dragon is meh... he's written a bunch of crap, but Silence of the Lambs and Black Sunday are great.
Thriller authors are hit and miss, but when they do it right it's often something magical. Silence and Black Sunday, fuck yeah. Nothing else I've read by him is worth a second glance in my opinion.
And check out Silence of the Lambs the movie again... it's tarnished by the sequels and prequels and stuff. It's one of the best movies ever made, full stop.