Most SharePoint sites I see are made by geeks, for geeks, with no sense of style. Is there a way to spiff up a site without having to go the SharePoint Designer route? Sure there is: include images, slideshows and embedded video using simple web parts and picture libraries.
A single large image on the top of the entrance page can make your site visually appealing without having to spend an inordinate amount of time on graphic design. Use the Image Web Part to insert a banner image across the top of the site.
A selected slideshow of interesting images is as easy as pointing to a Picture Library using the This Week in Pictures web part. A nice touch for a software project is to have a linkable slideshow of screenshots on the entrance page of the project site.
Finally, there is too much content on YouTube not to find something of interest. Go to YouTube, type in the term SharePoint, select the embed code and insert it into a Content Editor Web Part.
Standalone images, dynamically generated slideshows and embedded videos will help your End User coming back for more. By the way, don’t forget the content. You can still put your geek hat on.