Let's start with Card College -- If you don't have the set, you should. The teaching and effects are top notch.
For close-up in the hands, get the Art of Astonishment series.
For standing up in front of a group, get Drawing Room Deceptions.
For some really well crafted routines, get One Degree