It was one of those "songs that aren't bad, but I never want to hear again" (like "Stairway to Heaven", or "Back in Black") until I played it on Guitar Hero 2. Playing it really made me appreciate how good the guitar is throughout the entire song, main riff, solo, all of it.
It's use in The Devil's Rejects is more annoying than anything else, because Zombie was so committed to using the whole stupid song that the ending drags on forever. Good in theory (the song, thematically and tonally fits quite well), bad in practice.
Now, The Allman Brother's "Midnight Rider", on the other hand, got a huge bump into awesome territory from it's use in The Devil's Rejects.