Personally I use CTEs because they make my SQL code readable. I often reformat a SQL that contains plethora of sub-queries into a CTE to make sense of the logic before even attempting to run it.