Even Mike Holmes (TV contractor) admits the specialists lay waste to his guys.

I found a big 2200 SF+ split level house with two kitchens, two living rooms, and two entrances that would be 'effectively equivalent' to what we have now in a condo with a noisy family directly above us (that likely to hears our TV and bits of our conversations).

.), utilities, TV/internet, landscaping maintenance, marketing, credit card fees, lodging taxes, etc.

I don't know anything about the deal but after reading your post I googled the company and found a press release from Nov 2021 announcing that they had purchased The Aubrey.  

And this same issue extends in other directions, for example, what if one family member loves watching the big game all weekend long on the TV, but other people would like some quiet time to read.

(If you would like to track market expectations of rate changes, the FedWatch tool from the CME Group is extremely useful.)However, yields and mortgage rates can be greatly changed by Federal Reserve actions—the real drivers are the policy press releases and press conferences (typically scheduled for the early afternoon, a couple of hours after the publication of the decision).

That is why you should request to review all contracts related to the property (not just leases, but other service contracts too, like pest control, cable tv, etc. that the owner may have) during your due diligence period of escrow. 

And really low price points you're going to be hard pressed to find good returns as well.

Then when pressed turns out they haven't sold a condo this year and the inventory is rapidly on the rise (which i already knew)..

The internet and TV has lead to the massive spread of information regarding real estate investing in the last 5-10 years.