So if there's a property A, worth 500k; and generating 10k cashflow; property B is worth 800k and generating 15k cashflow positive; I'd still go for property B.I didn't include SFH because I don't need to buy a super large house and not be able to rent any part of it (I am not keen renting it room by room or sharing common spaces).

Has anyone used Limitless Motivated Sellers lead generating provider?

as simple as it sounds I live in a market where people are paying way over asking price yes Dallas and the city at that, I spent months looking and one days I went to my boss and he mentioned someone he knew selling a home at that i could obtain a better price than if I were just buying from any random person in this market.

This doesn't say much for the next generation. 

I've always been fascinated with building wealth and generating passive income, but I can't seem settle with one thing and run with it.

I'd come up with all your own assumptions to generate a purchase price. get it under contract, then confirm (via Ptax statements as noted below), your assumptions, if something is off, thats reason to kill the deal.This shouldn't cause so much headache for you, just fire off the NOI and see what happens.

Furthermore, there will be about $20,000,000 in home sales, generating well over $1,000,000 in fees.

If it’s an actual agricultural property and the buyer goes through Ag credit, expect more like 65% ltv (so 35% down payment).If it’s truly a business, market it as such and the price should be based on the cashflow it generates.

From a strategic perspective I am looking to buy and hold multifamily and generate good cash flow ( beating the market in terms of COC return).

Aside from that, I think you will find it hard to continually generate losses like you envision.