I don't know that they have a specific real estate focus, but from my experience they are good with the foreign-earned income or foreign tax credit stuff (as should be most CPAs?). 

They know that most foreigners are lifestyle buyers and are therefore only going to buy one property in their market so their incentive is to sell to you and make the highest possible commission.

I am a Canadian that has been looking at doing BRRRR in the USA, specifically in the Augusta area.I have a realtor, property manager, and rehab contractor in place.What I am struggling with is the foreign aspect for me.

Yup you'd do it as a fix and flip foreign national .

Bridge, portfolio, foreign national and other specialty loan products.KeyBank, flexible lender, HELOCs on secondhomes and rental properties. 90% LTV on primary.

I can go closer to home for that.I have mentioned in many replies to posts in the BP forums that the security risks for foreigners in Mexico (in areas where tourists go) are way overblown by a way too sensationalistic press looking for bad news to sell.

Cost of living is likely much cheaper, we just run into foreign country currency risk, etc.

I’ve qualified as real estate professional since 2021 and just found a potentially good opportunity to acquire a property in Mexico that would make for either a solid STR and/or eventually our forever home.I’m completely new to acquiring a foreign property- how to finance, what purchase process looks like, how foreign STR is taxed, does real estate professional status matter, etc. 

Looks like in my lease I have that it is the tenant's responsibility if there is a foreign object other than toilet paper that causes the clog but it fails to specify determining fault.

You will need to use a bank that is foreign.