Newb here, but saw CLR poll.
I've used CLR a bit for a database backed website. Used lots of simple function usually for text processing for example,
a function to determine if user input is a 5 digit number (zip code) or a valid email address (one line of regex). these functions are used to prevent sql injection.
Also, custom output of results. We produce files in a number of formats and have found CLR convienient in meeting clients format requirements.
Also Comm functions FTP, Email and file operations DoesFileExist() DeleteFile() CompressFile()