I did a Google search and yes the Recursive CTE does seem to have a HUGE performace disadvantage compared to a Loop. I'm still very new at this so my next question to research and understand is why.

Off the top of my head is it because a CTE is a derived table and it will have to go back and scan itself over and over to calculate the next proceeding values?