Ok, since I have been trying to get the hang of CSS for other projects I got going on (somewhat including this website) I figured I'd post up a good website involving use of CSS.
MeyerWeb
http://www.meyerweb.com/
Basically this is a site run more or less by Eric Meyer. Meyer has written a ton of CSS books in the past, and basically on this site you can find all kinds of neat things involving CSS. For simplicity sake go to: http://www.meyerweb.com/eric/css/ , this is the portion of the site that illustrates different effects that one can implement using CSS.