There is a lot of variability in this answer and, like all things in real estate, it simply depends. 

Being a subject matter expert, not because you are forcing it, but because you simply ARE, shows through, and investors are rightfully attracted to that. 

Has anybody found a workaround for this or would the seller simply have to hold the note long-term without the option of selling it?

And there is a constant mention of Guaranteed returns there is no Guarantee unless its the federal govmit on 250k or less FDIC insured .. this was simply investor greed.. investors did not understand what they were investing in what the risks were and were blinded by the returns offered.. no one put a gun to their head.. investor make bad investments all the time..  

So an identical neighborhood (income, crime, school quality, etc.) can cost you as much as a $100k less on the South side simply because your neighbors are brown or black as opposed to white.this right here is the gem advice.  

The country simply does not have enough affordable housing units, and the new supply of affordable housing units is not keeping up with new demand.

It might be best to simply go to a local REIA networking event and meet some wholesalers that have been doing this for 15 years and buy a deal from them.

A rider allowing for using your owner-occupied property as a short-term rental for a specific/limited amount of time is very different than an investment property being used as a short or long term rental 100% of the time.Also, telling your home insurance company that you STR your home occasionally does not give you extra coverage for those types of risks, it simply means if your renter burns your home down the insurance company isn't going to immediately deny your claim. 

The chart of accounts is structured around the Schedule E, so you simply export it and send to your tax professional.

On your own, you simply can not buy in the place where you want to live.