Thank you Jeff for sharing your experience. 🙂
I understand what you are writing. SQLCLR exists since 2005, but it is behavior as like currently released.
During years, I did not notice many useful pattern of using SQLCLR. Maybe Adam Machanic is an exception ( His code has a lot of sentence that contains "law words", so I am very careful with that 😎).
In my opinion there is a plenty of room for SQLCLR improvement. By that, I mean memory management, security model design, ability to compile .NET code on-fly etc.
Working as a software developer for 25 years, I concluded in early days of .NET that T-SQL knowledge is as important as .NET knowledge.
In other words, T-SQL is irreplaceable and only in some situations SQLCLR can help it.
So, again thank you for your valuable comment Jeff! 🙂