If you want to go way back, how about "Once Bitten" or "Earth Girls are Easy". His characters Vera De Milo and Fire Marshall Bill from "In Living Color" are priceless.
I really enjoy "Bruce Almighty". It's Jim Carrey but not too Jim Carrey if you know what I mean, and the fact that Catherine Bell and Jennifer Anniston are in it doesn't hurt either. Steve Carell is a scream as well.