I wouldn't do it. I am with you, I hate camping with a passion, but I have considered it in the past since my poor, deprived children have never had the "pleasure" of camping.
After talking to many people, some who love camping, I have discovered, as some have posted, it is much more bearable if you have all the right equipment. No way was I going to invest that much money in all the proper equipment for one weekend of our lives never to use the stuff again. I will "rough it" in a Holiday Inn, which is as close to camping as I will ever get.