This is a very interesting topic. CLR integration may not necessarily allowed in production most of the cases, but CLR integration can be of great help in non-production environments, such as importing data from websites, or utilizing the external resources (computing some complex stuff and getting back data etc).
There can be chances that we integrate the internal websites with our internal T-SQL solutions for company internal applications. So in short, I am always a big fan of CLR integration which provides more opportunities for us to choose.

Good article Eilert !