Would this be the ideal market, or are there other rental options we should explore? 

Every where you turn there are STRs going up on the market fully furnished because they couldn't pay the mortgage and bills with the rental income. 

However, if you inherit it through her estate, you receive a stepped-up basis to its fair market value at that time, reducing tax liability upon sale.Gifting it now has no immediate tax consequences unless its value exceeds the $18,000 annual gift tax exclusion (2024).

But, the self-sufficiency test for FHA loans can be really difficult in SF, meaning that the market rent from units you will not occupy must be sufficient to pay for the mortgage payment. 

Unless you are finding off-market opportunities direct to seller, I can't imagine the deals working on BRRRR.

Also should be a new market analysis every time, and with that comes negotiations back n forth with landlord and tenant.

What market are you referencing?

You should start with a focus on a 2 unit multifamily property in a market that you can afford to get into. 

If anybody local (especially other wholesalers) or anybody else even out of my market wants to connect, feel free to reach out!

Usually turnkey operators suck the equity out of a deal and sell at or above market so there goes the equity.