Or is it only memorable for Hopkins' performance as Hannibal Lecter?
What kind of great?
An overall amazing, historically important and influential film? No, not at all.
A great mix of writing, acting, editing, etc.? Eh, probably so, but maybe not. It's certainly a character piece and it is great at that. Not sure the rest is really up to snuff. But it's debatable.
I watched it several years ago, when I was really in to "The X Files" and realized that Clarice Starling is the Appalachian version of Dana Scully. Chris Carter ripped off that character wholesale...