So far as cannon rules go, nat 20 does not give automatic success in skill checks. Some GM's rule a +5 bonus top of your roll if you roll nat 20. I myself rolled nat 19 which is quite high even with my penalty to my roll. Which is kinda nice to be so 'pro' rogue for change. At least what comes pick pocketing and picking locks and other rogue stuff :).