Got some examples of that?

CTEs are pretty much 'named subqueries'. The whole query still runs in one go just as it would if the query defined in the CTE was in a subquery, it's not like a temp table where the interim results are stored somewhere and then reused.

Sometimes doing things all in one is faster. Sometimes dividing bits up and using temp tables is faster