The best option with no gambling is MGM. MGM Gold will give you no resort fees and some comp rooms. If you don't play, the comp rooms will eventually go away. To reach Gold, you need 75k tier credits (TC) which is $9375 of theoretical loss.
If you get the MGM credit card, it gives you automatic Pearl status (basically good for free parking) but you still have 0 TC. If you spend on the card, you get 3 TC/$ on MGM destinations, 2 TC/$ on gas and grocery, and 1 TC/$ on everything else. You also get 4 TC/$ for every dollar combined that you spend on hotel charges. The easiest way to do this would be to spend $10k on hotel charges at 7 TC/$. Something like $5k on hotel charges at 7 TC/$ and then $35k CC spend at 1 TC/$
would also work. You can only waive resort fees on two rooms at a time though.

Assuming you are willing to have the rooms spread out, I would also look into Caesars. The easiest way to do this would be to gamble and hit Diamond on a 10x multiplier (15k TC), which would give you waived resort fees. The problem is that Caesars only waives resort fees for one room at a time. The credit card gives you 5k TC per year by spending $5k and a one time opening bonus of 2500 TC. However, spend on the card card gives you reward credits instead of tier credits (TC), so spend on the card is completely useless. Therefore even if you got the card, you would have to gamble the rest.

The rest of the properties don't really have other good options. It might be cheaper to book a multi bedroom suite at Elara than multiple rooms, not sure.