Actually CTEs tend to be better for performance.

Downsides are that they can be difficult to learn at first.

They can reference themselves which is awesome but you can get stuck in a loop.

Sometimes you may want to break them up so you won't hog up memory.

If you do recursion there is a limit for certain variables.

That's all I can think of but I am sure there is more.