There’s nothing better than examples of how something was implemented so you can copy it. JOPX on SharePoint 2007 has a bunch of links to other posts (which we copied below) for examples.

• How We Did It – Tag Driven Information Architecture using MOSS 2007 for the New Zealand Ministry of Transport
• BinaryWave Sonar – Component Level Performance Measurement Tool for SharePoint – How We Did It
• How We Did It: Building a News Workbench on MOSS 2007 for Microsoft’s Corporate Intranet Portal
• How we did it: Australia National Native Title Tribunal website – advanced web content management
• Tomoye Ecco and SharePoint Integration – How We Did It and What We Will Do Next
• How We Did It: blueKiwi SharePoint Connector and OfficeAssistant
• How We Did It: Integrating Telligent Community Server Evolution 2008 with SharePoint Server 2007
• How We Did It: Connectbeam Spotlight Connect for SharePoint
• How We Did It: Christian Children's Fund extranet powered by SharePoint