TnR's
I would agree with Aris, TnR looks great, but is HIGHLY impractical in a real world setting (IMO).
As far as classic piece by piece restorations -- and by classic i mean, true to the hollingworth style -- I think torn is a great TnR. It is highly visual can be done with a signed card, and doesn't really require any 'gimmicks' just some prep work.
If you don't mind getting your hands dirty and using gimmicks/prep Jordan Johnson's 'Holy Grail' is probably the most visual -- and easy -- piece by piece TnR on the market. There are no extra pieces, no cover, it can be done completely surrounded, and at the end all the creases are removed and the card is handed back to the spectator to keep. This TnR is rock solid... and SOOO easy, its almost sinful.
Also, don't get 'Unripped' by Gared Crawford, unless you are a huge fan of ruth goldberg. It would be a great effect for a stage show, but for the ridiculous amount of work it takes to set up/ perform you will probably never do it. Its a good DVD if you want to get another perspective on TnR effects, but you will probably laugh out loud at how complex it is (especially what he calls the 'complex version) I know i did...