From my experience, the best sampling rate is the one your A/D is designed for. Some A/D converters will support 192Khz, but because of the components used inside they may perform better at 96Khz, rendering the expanded sampling rate a mere marketing tool. Personally, and this isn't just my opinion, I would say anything over 96Khz is a waste. I've also concluded that, if your ultimate destination for audio is MP3/MP4, and you're not recording classical or sound-track material, 48Khz is just fine. Save some drive space.
With the new upsampling processing, you really get the best of both worlds in saved drive-space, but higher sampling rate processing. Although it takes a bit for me to trust the theory and technology, I'm willing to use it if my end result is pleasant.