Did some google searching and these sites had great examples of some cool stuff that can be done if you invest the time.
For Data Visualization: http://www.webdesignerdepot.com/2009/06/50-great-examples-of...
For Photography Galleries: http://vandelaydesign.com/blog/galleries/best-photographer-w...