Dear Hippocampus - you are, as has been the case in the past, absolutely correct in your observations. We have had student rentals in the past and built "Section 8" housing (that I refuse to own on a rental basis) and workforce housing, unsubsidized. In this process we have experienced many of the issues you have mentioned.
Our defense here is we are also the owners of the management company but have created this entity on a hands off basis a.k.a Staff manage the day to day. This need not be the exact model as there are good management companies out there (and a few less so) and generally their fee is worth paying as opposed to short term renters acting alone. Managing average daily rates and occupation, target marketing plus endless renter issues is not worth the phyrric victory of an additional $$ margin. Its not passive income but we have found the risk has been worth the effort long term in comparison to other more risk free options that exist.
I can only report on what has worked for us, with a careful selection of rental market and product and building ourselves to create equity from day 1. Probably the most advantageous angle of this approach is the inflationary hedge. As long as the asset metaphorically washes its face (income>expense) then the investment is protected against the ravages of inflation and we retain a plan B should plan A no longer be viable. We have also experienced a bunch of named storms, painful short term, but planned for and, so far at least, nothing catastrophic and not covered by business interruption insurance (also keep off beachfront properties).
This really is a shades of grey scenario and I would not deign to recommend one solution over another but can report on what worked for us. I noticed reading through the general thread that the choice was generally viewed as binary, either one or the other but not both. My reply was to illustrate a third way that would also be easy enough for others to mirror given some planning and a modicum of luck or aptitude. Regards, Chris