Does cloudpaw ever return in warriors?

Yes, because in A Dangerous Path, he becomes a warrior (now Cloudtail) in Chaper 18. "A Dangerous Path" is the 5th book by the way. I'm guessing your on the 4th book right now "Rising Storm" because that's when Cloudpaw is taken away by the "Twolegs". Enjoy the book:)