One of the websites shown in "Show off your Drupal site" is http://matthewharding.com.au
The site is using a hover image effect using CSS3 and the author gives the link to where he got the css from, http://tympanus.net/codrops/2011/11/02/original-hover-effects-with-css3/
To make it work with Drupal he says that he uses views rewrite the output to match the HTML. I can get this working on a non Drupal page, but have not managed to crack getting this to work using views, some partial success, but I think I am missing something somewhere.
Pointers in the right direction would be appreciated, thanks.