This is the only known footage of a Sturmmoersertiger in combat; taken during the Warsaw Ghetto Uprising of 1944. YouTube - STURMTIGER - RARE FILMING - at the Warsaw uprising Also used in the uprising, although not shown in the video, was the 600mm Karl train mortar, shown in this photo firing it's massive gun into the Polish lines: File:Karl6.jpg - Wikipedia, the free encyclopedia and a video of the Karl at Warsaw as well: YouTube - Mörser Karl - 600mm German Mortar Incredible machines, although their combat effectiveness was low and they were incredibly expensive.
I believe i saw footage of goliaths being used to blow up strongholds. Also there was the 'homebuild" Polish armoured car:http://en.wikipedia.org/wiki/Kubuś Aglooka