My primary focus is on the BRRR method, with a greater emphasis on appreciation over cash flow.For those with experience investing in Cleveland, I’d greatly appreciate any insights on neighborhoods worth focusing on.

I've been on the western slope for over 30 yrs.I built my primary, its; Slab on grade, stucco, concrete roof, painted with E-84n roof soffits and tailings fire caulk (anti-ember) vulcan fire vents, 4 car wide concrete driveway, extra large house numbers, red 3/4" hoses on reals @every corner, completely denuded of vegetation 100ft.

Is acquiring a new primary residence and renting your current home feasible?

and then using a HELOC on my primary and some cash for the JADU/ADU projects. 

Others required that the house is a primary residence.

(May also cut significantly into the current cash flow on it)I know you mentioned not doing a HELOC on my primary, but wouldn't it be advantageous to have the ability to pay off the line of credit instead of be stuck in a payment that is much higher? 

In addition, you've got your HELOC on your primary you'd have to be paying back also.

Sell your house if you have lived there 2 out of 5 years as a primary.  

i think this is a decision only you can make. im in a similar boat (house hacking my primary) and considering renting the whole thing out to get a solo home for myself. certainly a lot of appeal in that, given how much work goes into the house hack. but whether or not the numbers on cash flow align is up to you. personally i dont think $150 (seems like about 12%?)

Some custodians may offer access to platforms with investment opportunities, as well.