I'm wary of recursive CTEs as well. And concerned that because something appears clearer, you use it instead of something better. Another thread had a discussion on a left join v exists and how one is clearer to read, but not necessarily better.