I did a presentation on how to create killer user profiles at Sandcamp 09. I talked about how to use several modules together and integrate them all with a custom template for the user profile. I also talked about how important Views are, and how a simple snippet of code to embed a view can put lists of your information on your profile page.