Has anyone created a twitter like app in Sharepoint 2007? Would really like to know about your ideas and suggestions.
There are a few options for you.
Aidan Garnish has a solution here: http://aidangarnish.net/blog/post/2009/02/Twitter-SharePoint-web-part.aspx
There's a CodePlex project called SharePointTwitter here: http://sharepointtwitter.codeplex.com/
And if you just want to search twitter there's a web part here: http://www.mattjimison.com/blog/2009/03/04/twitter-search-webpart/
Hope that helps!