This with the electrical issues are definitely red flags but going off of what professionals here have said it’s not enough to turn away the deal.

Most attorneys will not take these cases unless there is extreme negligence and there is money to be made.It is a BIG red flag that they will not let someone in to inspect.

What are write-offs that raise red flags? 

But, as landlords, if we all do it, our tenant screening will show those red flags.

The involvement of onsite management, often seen as a potential red flag, can lead to the property failing crucial qualification tests.

I was used to doing deals in jackson MS and Birmingham so I was a little shocked when i saw the as is price there in Charleston.. 6X or more higher than other parts of the deep south.

I suggest to make deep research about the location and risk or ask experts personally before take actions. 

Groups like to advertise the "wins" on their websites, but they aren't showing the current losses and deals on the brink of foreclosure.Find an actual person in your market, who has actual and deep experience to partner with on your first few investments. 

Thinking STR may be good given proximity to Red Rocks, although not sure of STR laws per above?

Most DSTs have a disposition fee on the back end that they only receive after they've returned original capital, giving them an incentive to do so.Work with a group that has experience with the sponsors and knows what potential red flags to look for in each offering so you might mitigate potential risks.