I lived in the 'system' and I lived on campus. IMHO on campus was much better.
After a FR year in the dorms I thought I was really missing out. So I joined a house (doesn't matter which one) and after a year in the 'system' I was back out. Now all of this happened almost 20 years ago so take it for what it's worth.
Rape and drugs were 100 times worse in the 'system'. Amount of work to be in the house was also pretty sizable. I got along with the guys in the house fine and had a couple that I thought were friends. In the end not so much. There is only one guy that I still talk to, and even that is sparingly.
FTH...for the house. That's what your life becomes. Cleaning, projects, events, and countless other activities.
My advice is befriend several frat guys and get into their parties. Play the game and always be 'thinking about joining a house'. You get more benefit from it and less work. You can ditch frat friends easily when you find out things are not what they appear...and if you find a group of guys you really like then consider joining.
But just like jobs, don't confuse the interview process with the job. They are not the same thing.
One final note. There was a guy that destroyed $150 worth the property at the house. He didn't pay the bill and they booted him. From what I was told he was a nice kid when he came to college. He lived in the house for 4 years and for his 5th he moved off campus. I only knew him as a guy who partied and did drugs (everyone admitted he wasn't that way when he came into the house, but he hung out with some 'bros' who did the same thing) and thought he was an ok guy but not someone I wanted to associate with. The next fall they booted him for the $150 bill and all his "bro's" and 'friends' treated him like he had aids. His drug use evidently got worse and he shot himself that fall.
Am I saying the house killed him? No, I won't go that far, but they never helped him either. They exposed him to that life (not all but a good sized group of them) and when, knowing that he was having major issues, things were at their worst they abandoned him. My 'friends' don't do that. My brother sure as hell wouldn't.
Just go in eyes open.