Another one worth checking out was the Ferdinand (named after Ferdinand Porsche, the founder of Porsche and inventor of the VW Beetle. It was so heavily armored that the allies couldn't defeat it's armor at all. With very few exceptions, only mechanical failure and lack of fuel brought it down.
http://en.wikipedia.org/wiki/Elefant