I've seen programs that go down to a $100,000 USD loan amount for foreign national DSCR loans.

Here's a breakdown on loan options to consider:FHA Loan: @Brittany Minocchi is right in looking at FHA option.  

I'm eager to learn about how to find and fund properties that help my family financially and my community with affordable/reasonable dwellings for young families and newlyweds.

Sounds like you're asking for a private lender to go into second position to convert equity into cash behind an existing loan on these properties. 

But everyone has their own unique financial situation, financial goals and risk tolerance.

If you need financial help, ask under the "Finance, Tax, and Legal" forum.

Bigger Pockets is a great place to find a real estate tax accountant.A good real estate accountant can save you thousands of dollars by leveraging entity selection and formation, tax deductions, cost segregations, bonus depreciation and tax planning.I recommend finding an accountant who specializes in real estate taxation, business taxation, financial planning and tax planning.You may want to consider working with your accountant remotely to expand your options.I would also recommend looking for a accountant willing to work with you throughout the year.

Commercial mortgages are really DSCR loans.

Since this opportunity came up, I've begun to take real estate more seriously as a path to financial freedom.

If your current lender can’t accommodate you, explore STR-focused lenders like Host Financial or Lima One Capital, or consider bridge loans to buy time while you build your rental history.