David,
I can't find the one that has a better list of types of adventure games puzzles. At least -
check here or
here and see if it gives you some types.
Also, there is this casual game - Azada that has a lot of the types of puzzles found in adventure games. You might like to try the demo.