Here we see some nice video (with music) of three contraptions:
1) Conveyor Belt
2) Lift and Dump
Want more? OK! Here is a link to a whole bunch of Lego contraptions on YouTube.
If your aspirations are somewhat more modest, look into the book/kit Lego Crazy Action Contraptions. I haven't played with it myself, but gets truly outstanding reviews.