I'm quite curious because despite the great capabilities of writing CLR-based stored procedures to off-load those nasty operations TSQL isn't that great at (like iteration, or complex math), I'm continuing to see a wealth of SQL 2008 databases with complex stored procedures and functions which would make great candidates. The in-house skill to create the CLR code exists as well, but there is flat out resistance to use it. In one scenario I was told "Oh, iteration isn't a problem because we've trained everyone to use WHILE loops instead of CURSORs" (um, still iteration folks...find a set-based solution or get that 11-hour processing stored procedure out of TSQL!).
So, who uses them? What do you use and what kinds of problems have you solved?