The properties I have come with instant Cash-Flow opportunity.

I'll quantify, suburbs of Rochester, NY in Monroe county east of the Genessee river, see 5-10+% appreciation for the next 4 years as measured Zillow home price index.When talking on historically the US was a-ok on kick-the-can economics, REMEMBER, 60 of the last 100 years Europe and Asia were in some state of burning rubble.

I was burned out on the mortgage side, and made the transition full time  to RE. 

Nah, the contractors aren't upset, when you see someone's home burn down it changes your perception.

A reasonable person would assume if my rental burned down a couple months ago they would've left me on the hook for it all, meanwhile paid for the coverage all year long.

The neighbors also mentioned that "he is well known around the neighborhood for sleeping in vacant homes and has already burned down 3 of them." 

Title says most of it, my realtor has a relative with a duplex with burn damage in Oregon in the area I'm looking to buy my first househack.

This determines instantly if a lender will touch it.Another factor: STR financing is getting harder to come by (at least in the DSCR space). 25% of the industry used to lend on STR's, now it's less than 10%.And it being a condo, expect anywhere from 15-25 bps added to the rate.

Any agents work at a brokerage that offers you access to instant buyers like eXp Express Offers, etc?

Real estate is a slow game, where you don't become instantly, but its return can be beneficial in the long run.