As someone with no experience investing into a syndication, is this normal, a red flag, or possibly ok depending on other variables?

Go under contract with a ~45 day closing, rehab for 30-60 days (costs wrapped into the loan)..during this time you can market for tenants, then move in. 

After finally getting into Hostaway, I felt it wasn't for me and the customer service was not very prompt or helpful with the issues.

This is the place to be if you're looking to learn and get into RE.

I would like to look into multifamily, or a single family. if I could find something like this link at bottom.

Whether you're a seasoned investor or just getting started, finding the right financing can make or break a deal.Would love to hear your experiences, tips, and any questions you might have about securing financing for flips.

That is why you tend to see builders offering such a big "Builders Credit" it’s because it's "Ghost Money" it really doesn’t matter or exist to an extent.A builder can go into an area build 20-30 homes for example, buy the first 2-3 homes paying top dollar so they can set the market sales.

Essentially turning the single unit into a duplex, does anyone know of any SBA funding for this type of project?

Yes but this is the 1st year it's gone into effect.

I’d argue that location, pricing, and guest experience are even more important for long-term success.Hope this helps, and feel free to ask if you want to dive deeper into any of these areas!