I was in a fraternity in college in the early 90s. The answer to the OP’s question is largely “depends”. Fraternity culture can vary significantly between different houses and even within the same fraternity across different schools.
Generally, yes, there is a consistent theme of a bunch of dudes hanging out drinking and throwing big parties and trying to get laid.
Also, yes, we had what was called a “files room” of people’s class notes from prior semesters.
Fraternities at my college were more or less the “30 dudes living in a mansion” type you see in the movies. Although some of the newer ones looked more like a Motel 6. The typical layout for most houses consists of bedrooms (typically singles, doubles and triples), a large common living room (often with pool table and large TV), large dining room that can accommodate the whole house with an industrial-style kitchen. Houses were typically staffed with a cook whose salary was paid for through fraternity house dues in lieu of a campus meal plan.
Fraternity houses also had a large “party room”, which was basically a big concrete room with a bar, some sound equipment, party lights and a drain in the floor. When parties weren’t happening, often the party room was converted into a sort of lounge, sometimes with Beruit (A.K.A “beer pong”) tables.
My fraternity didn’t really “haze” beyond some minor excessive drinking (which they were doing anyway). But like all houses, we did have 8 weeks of “pledging” where the new members are required to be at certain places at certain times, learn about the history of the fraternity and perform what basically amounts to house chores. Sometimes we fuck with them by telling them to get all their homework done by Friday so we can kick their ass all weekend at the house, but then we surprise them with a road trip to Penn State or wherever. I do know that some other houses were a bit more asshole-ish about pledging. Pretty sure a lot of the more extreme stuff is mostly urban legend.
We did party a fair amount. They were usually open to pretty much anyone and alcohol was given away for free (to get around various state liquor restrictions). Parties typically consisted of the following type:
Weekend house parties - Legal parties that ran from 9pm to 2am on Friday or Saturday night and had to be registered with the school. Beer only. Typically held in the party room or other large common area where the fraternity could go through the motions of pretending to check ids and whatnot. Roughly equivalent to the “toga party” scene in Animal House.
Cocktail parties - Legal parties than ran 7pm-9pm on Fridays and Saturdays. Basically what it sounds like. Everyone gets dressed up like Yuppie jerkoffs from a Bret Easton Ellis novel and gets hammered on screwdrivers, sex on the beaches, tequila, Jell-O shots, Mad Dog and/or Boones wine.
Hotel parties - Illegal parties held on Thursday nights. Held in the individual brother’s rooms (as if on the floor of a hotel) so as not to be visible from the street. Typically smaller scale but could get pretty packed (you don’t want a line of people in front of the house drawing attention). As they weren’t allowed anyway, you could pretty much serve whatever you wanted (including weed). Some guys might be doing drugs in one room. Others playing “Asshole” or some other beer game in another. Sometimes we might also extend the party to the party room to play Beirut or dice games at the bar.
Monday Night Football - Not so much a formal “party” as the fraternity hanging out with a bunch of friends drinking and watching football (again, often incorporating the Beirut tables and bar games). Also a popular “rush” event.
And of course there were variations of parties like “toga”, “80s”, “70s”, St Patrick’s Day, Halloween, etc.
Even if we weren’t throwing parties, there was often a low level of “partying” such as groups of guys drinking and watching tv, “pre-gaming” before they go out somewhere else, beer games, hanging out with girls, whatever. One time I had to explain to a visiting friend from Villanova that this was not the “party” we were throwing, it was just “everyone hanging out until the party starts in a few hours”.
FWIW, we didn’t spend every moment in the fraternity house. Every house doesn’t throw parties every Thursday, Friday and Saturday night. So it was quite common for fraternities to visit each other’s houses. And of course, some got along better than others. Off campus parties were also popular, as were several local bars. Occasionally we would visit other colleges in the area, but it was usually more common for them to show up at our school.
Occasionally you had fights or minor “chest puffing” what with all the alcohol mixed in with rival fraternities, GDIs, drunken townies, drunken freshmen, drunken local high school kids and other “randoms” looking to get drunk for free at your house.
As for girls, one of the main advantages of being in a fraternity is that girls tend to like to go to fraternity parties. And living in the fraternity, it makes it convenient to go back to your room to hook up, rather than trek across campus. Fraternities also tended to “brother/sister” up with one or more sororities. Throwing joint (as in “partnership”, not “marijuana”) parties, generally hanging out and whatnot.
That’s more or less the gist of it.