One thing I'd like to see is that I can create a CLR proc, which can connect to other sql servers via SMO, and then get some information I need, such as how many databases and their sizes on those remote sql servers. I believe I tried but failed because SMO cannot be used in CLR (?), I cannot remember the exact errors though. I even tried to write a CLR proc to read Excel files, but I believe I failed as well.
These days, I simply rely on PowerShell to do my work but I still dream someday, I can use CLR to do the work directly inside SQL Server, from SSMS. :-)