But the value that can be added in high value markets is greater than in low cost markets.My last value add (purchased Dec 2021) was purchased off market at $2.25M and was appraised at purchase at $2.5M for the loan (so on purchase I "made" $250K). 

From a lender's perspective, we struggle to get good loan officers.

Secure financing through conventional mortgages, FHA loans, VA loans, or private financing.Start searching for properties that meet your investment criteria and financing options.

Ive also seen others use the method of a DSCR loan with ($8K-12K) Down.

I'd rather go with a conventional loan to get a lower rate and fee.

When it comes to finding a lender for a DSCR loan, does the lender need to be in the same area as my property, or can I choose any lender, and they'll get me the loan out of state? 

You will also need to see if they have a loan on the property and how much you would be putting down. 

In every transaction the buyer would be getting money to put for a down payment and then funds from a third party are the balance of the loan.

In terms of doing a house hack, you likely will want to do a 5% down loan or something similar.

The likelihood of the bank calling the loan isn't super high, however that is completely dependent upon what bank holds the loan.