I'm doing a webcast for MSDN on 6/22 on the topic of selecting T-SQL or SqlClr features for your data access applications. If you get a chance, check it out. Also, some other presentations and projects that I'm involved with are listed here.