Early 90s point and click adventure games all have a charming humor to them. All to a various degree. Off the top of my head:
- Full Throttle
- Sam and Max (I heard the recent episodic ones are pretty good too, but the original is one of the greatest games of all time)
- Thorin's Passage
- Monkey Island (1-3)
- Day of the Tentacle
- The Legend of Kyrandia (1-3)
- Space Quest (5-6 especially)
- King's Quest (6-7 especially)
- Grim Fandango
There were others too... basically, think of it in these terms: in those days, PC games weren't made for 12-year olds, and the genres were also generally slower and more casually-paced, so the writing was generally significantly better. The games themselves (as in, gameplay-wise) are not necessarily too good; however, with the help of a solution manual (can be found anywhere) all of the games above can result in time well spent, and probably more than a few laughs.