Personally, I didn't enjoy either of the Pet Detectives,or most of his 90's work as a whole. Cable Guy, The Truman Show, Man on the Moon, Eternal Sunshine, and Series of Unfortunate Events are all amazing however. In these movies he was giving a great performance both understated and audacious as the scenes called for it. His "classic" films have always seemed to boil down to "Jim Carrey can't tell a lie!" or "Jim Carrey is literally a cartoon!" or "Jim Carrey is Jim Carrey!" (Pet Detective).
It is his later work that really showcases his talent as both a comedian and an actor as a whole.