Two recent programs come to mind and I'm sure this list is not exhaustive. "The boys" and "Orville". Both chock full of "heroes" who in-between being heroes are preoccupied with banging each other, getting drunk, eating or failing themselves. The last episode of "The Boys" ends with Homelander jerking off while perched on a ledge over the city and raging at the unfairness of life. It's certainly a comment on the blandness of the Marvel universe and Orville is a superior and cutting rip off of Star Trek which has become bland and inoffensive in it's latest incarnations. Orville cuts pretty close to the limit for whatever rating it has. The two "gay" aliens and the holodeck porn episode come to mind. It was done fairly well. Stressed out officer on a star ship gets a holodeck porn addiction and is no longer able to relate to or face his life partners demands for attention. It's not heroic and not glorious but relatively human. Orville's officers like to fuck. They order booze from the matter synthesizers and they get depressed and do stupid things. Of course it is still "star trek" and there are always happy endings and everybody learns a lesson at the end. It doesn't drift too far from the genre.
However the article takes a selective slice of current cinematic culture and tries to pretend there are no other options out there whilst at the same time looking back at 80's and 90's cinema as if it was the age of body positive cinema.