My wife and I tent camped for several years including from Kentucky up and around Lake Erie, Niagara Falls, and back to Kentucky. We had a lot of fun, some beautiful camping and we loved it. We discussed one day buying and RV.
We wanted our kids to experience tent camping and they got the opportunity; however, the trip that changed was, as some have said, rain. Our family went camping with another family and it rained the entire time. We had the dog (small dog) and the four of us in a six person tent, most of the weekend and while the tent did not leak it smelled like wet dog and to top it off one of the kids got sick from eating too many smores probably; so now the tent smelled like wet dog and vomit and that was it. We got up at 6 am packed the SUV and headed home - miserable!
We did not buy our TT right away but we didn't tent camp anymore, we had it with tent camping as a family. We purchased our TT in spring of 2014 and our family has a blast camping as much as we can.
My wife and I are still agreeable to tent camp if the two of us need to when necessary, and my son is a cub scout so we will still tent camp for outings but no more family tent camping trips; we are too used to the TT conveniences.