We have a Starcraft 239tbs and absouloutly love it. It's extremely roomy inside and can sleep 10 "comfortably". I say it like that because while 2 adults fit in the queen fold downs fine, the dinnet and couch are better suited towards maybe 2 children each. My feet hang off the end of our couch when it's in "bed mode" lol!! We have 3 fold down queen beds, plus the couch folds out into a bed then the classic table dinnet bed.
As to the noise, it's not bad, but we are used to using a PuP in the past so it's no different. The canvas ends are secured the whole way around the bottom so really no big threat of water seepage.
Good luck in your decision!!