Check out this Lego Great Ball Contraption. If you know Japanese (or how to use Google Translate), you can follow his blog here.

Here's some stats:-
+ 500 balls running at 1.0 balls/sec
+ size : 1.5m×6.5m
+ path length : 31m
+ construction time : 600 hours

It's just totally mesmerizing ...