Not only is Greek Life different at each school, but the way they go about it is different as well.
My D focused on and attended a LAC and pretty much all of the LACs we visited had sophomore year recruitment. We all felt that sophomore recruitment was preferable as students had a chance to solidify friendships freshman year before deciding if they wanted to pledge, had time to get a good sense of each sorority/frat,etc. My D surprised us and joined a (low-key) sorority and it did add to her college life. There was no hazing at her sorority (just silly things like having them sort sprinkles by color and then they had an ice cream party). Also she maintained her friendships with people who did go Greek. My D is in grad school now and is living with two sorority sisters who are attending different programs at the same school. All in all it was a plus for her.
Bottom line is I think it is hard to predict. It is a matter of if there is a sorority/frat on campus that would be a good match for you child.