My web and software company is still using ColdFusion and many others are too. I have been using it since version 4 in 1999. It may not be apparent that the websites are ColdFusion based by looking at the file extensions as many developers, including our own here, hide the .cfm file extension and replace them with search engine friendly filenames.
CF is still a good platform and is easy to use even for very large projects. Code is generally shorter but requires more server resources compares to other platforms. There is also the cost as ColdFusion Standard costs around 1000GBP. If your hosting provider already offer ColdFusion then this isn't a problem. We host all our own sites so we had to purchase all the software ourselves.
Some examples of our sites are here on our web design portfolio page. All the sites there are ColdFusion sites but all have the .cfm extension hidden. The data comes from MS SQL databases on all the sites.
I hope this has been some help to you.