I.E. All cash invested $1m

Market value: $1.2m
= 83% cost to value (17% profit)What are people usually aiming for at a minimum? 

You don't want to narrow your buyer pool when you sell your house in future just because they might don't want the ADU but decent size backyard is always good and has its potential.If I were you, I would rather try to find deal in hayward/union city/san leandro single family house.

In summary, do you think it's a good idea for me to partner with someone for my first deal, put in some or all of the money, take a smaller return, but gain knowledge and confidence to start on my own in the future?

If not, let's still stay in touch for future opportunities

Another thing you can do is ask a local Property Manager what they expect it to do.

I currently lead a family group of real estate entrepreneurs/novice investors who are looking to supplement our current incomes, build wealth and create financial independence for ourselves and future generations. 

We need this house rented to lower our DTI.We want to buy small MTF in the future to househack in CA using low downpayment maybe FHA loan.Thank you in advance

Thank you so much for taking the time to read and respond to this post, and I look forward to networking with you all in the future.

Best wishes on your investing future.

If I am aiming for the national tenant, what kind of TI per sqft shall I expect, how much security deposit I shall collect and  how many month of rent I shall ask tenant to pay advance to execute the lease (1st and last month of rent or more)?