Well, I have semi-sweaty palms, but the last time I can remember was the Rainbow Roller-coaster level in Super Mario Galaxy 2. Take my least favorite Mario Kart map of all time, and mix it with Super Monkey Ball, and you got yourself a perfect sweaty palm solution.