Elvira is just an OK game in my mind. The shots get repetitive, and the scoring isn't clever enough to make up for that. The art is OK, and sound is pretty decent. There's nothing in the overall package that makes it particularly fun for me.
I have a feeling this game's popularity has to do more with Elvira herself and the cheesecake theme than the actual game.