So I would definitely lean toward BRRRR between the two options although BRRRR is difficult in this market.For the large majority of those starting out, I recommend house hacking although I don't know if that would work for you in your situation.

I am lost on which avenue to take from the options of house hacking, buy and hold (short-term rental), buy and hold (mid-term rental), buy and hold (long-term rental), BRRRR, flipping, etc.

I work in analytics consulting and have managed my finances and investments well by myself. 401k, investment accounts, high yield savings account, own a house in a nice neighborhood with a traditional 30-yr mortgage, etc. 

I would check with your local bank for opportunities to get a line of credit - I wish those things existed in the private lending world, but they are non-existent for the time being.

My plan was to put down 35% while she would cover the remaining 65%.However, the seller has requested to be in escrow for 45-60 days so that he can complete a 1031 exchange and use the proceeds to buy another house within that period.

Do you own a house?

Limited space for expansion ensures a housing shortage, driving up property values and rents.

That depends on who runs the White House, whether China invades, whether Yellowstone blows up, and 10,000 other unknowns.

Then she texted later that “you better come fix it, there are 3 minors in this house”.

You need to provide them with the LLC information and the trust documentation when opening an account.I have opened bank accounts for the trust and for LLCs owned by the trust at multiple institutions, including one of the four major US banks, local banks, local credit unions, online banks, multiple major brokerage houses, etc.