I'm specifically looking at a property on Lake Monroe.

I can't add a lot of advice to the specific strategy, but I would urge you to focus on simplicity.

Wanted to get some thoughts from more seasoned small multifamily investors on a few items or any other suggestions:- Any specific pros/cons of any particular states in SE (TN, AL, GA, NC, SC) to consider?

It would be hard to cash flow on a 600k house that has 3600 in rent regardless of the broader economic situation going on in society. i find that when someone says BRRR doesn't work anymore they end up meaning it doesn't work well for the specific types of real estate that they want to buy.

AND just because you have experience and a “good deal” doesn’t mean you will be successful trying to syndicate the deal.The first criteria is does the sponsor have the general knowledge and experience in real estate, and the specific knowledge and experience in the property type/location to give the project the best shot at success?  

What precisely went wrong?

Just personally, I would never do an absentee landlord kinda thing....Too many moving parts, too much to go wrong and cuts into your profit big-time....Sentimental value is one thing, but not if you end up hating the house down the road.....Stay local, plenty of opportunities in good ole AZ.....

Consider all the things that could go wrong and see if the lease addresses them: unauthorized pets or tenants, early termination, security deposit, lease violations, late rent, eviction, lawn maintenance, parking, etc.5.

Are there specific lenders or loan types I should look into?

Not sure of specifics.