Should NCOs inspect barracks during the weekend?

no

What's the big deal when I was in 89-97 my leadership would go through the the barracks whenever They wanted to sometimes 2 or 3 times a week and they would inspect off post personal once a month as long as the soldier was home

This nothing new this was done in the "70's / "80's when I was in Germany. I lived in the bus. At first then married off post. It was not inspection per day. Checking on the your soldiers just like you should do today.

Micromanaging at its finest. If its fucked up on Fri-Sunday, it will still be fucked up Monday and they'll pay the price then. If you really wan't to crush morale and make soldiers feel like they're prisoners, by all means inspect their shit every day. This isn't the venue for mass punishment, this should be a case by case basis for these inspections, because most soldiers will keep their room clean. You get that one dirtball that needs constant attention, have CQ do checks daily and enforce the order to keep the room clean.

Okay, so how is leadership ensuring their troops are living in safe, sanitary conditions? The Navy rule is division officers are to inspect their Sailors' berthing every day (while import only weekdays, the duty officer does it on weekends). While ensuring racks are made and gear stowed properly, there is also the cleanliness and proper working order of air conditioning and bathroom facilities. Lights stay out for those sleeping due to watches or overnight work. Taking care of people is not giving them what they want, it is ensuring they have what they need to be safe and successful. Oh, the married quarters are required to be inspected by the facility commander, and that is by discretion. He/She is still responsible for safe and sanitary conditions.

I was active from 82' to 85', the Army in their infinite wisdom made me an instructor. As jr. enlisted I lived in the barracks, we had daily room inspections to make sure the rooms were in order. Aftre hours and on weekends the CQ on duty inspected the common areas to insure they were clean. Somebody was assigned to clean the common areas every day to keep them in standard (trash emptied, latrine not trashed ). Why should it be any different today?

I guess someone screwed up enough times to bring them back. USAEUR stopped them back in the 90s when I was there. They said if you do it for the barracks soldiers you have to do it for the married soldiers. That went over like a lead brick with the FRG and then we only had health and welfare checks for both. Way to go USAEUR.

What happened to the CQ, doing there hourly walk through and the SDNCO with ther once before and once after midnight rounds? ( Or am I so old they don't do that anymore.)

As long as nobody is getting hurt and nothing catches on fire and the barracks are good to go on Monday, let it go

The NCO can and will inspect at any time, without notice. SUCK IT UP!