The Content Editor Web Part is truly the most flexible web part available in SharePoint. There are several Web sites devoted specifically to this like http://www.contenteditorwebpart.com. One of the recent articles I came across and wanted to share is one where a client wanted to change the default behavior of a document library to open PowerPoint in edit mode instead of slide show mode. Here is some pretty cool code on how to accomplish just that.