I am looking to purchase real estate for both investment purpose as well as to offset as much tax liability as possible. 

My business partner and I have a monthly fix/flip forum we hold in Scottsdale and mainly just work with flippers/investors. 

I love the flexibility they offer for traveling professionals, military families, or folks in between moves.My main questions:Have you noticed increased demand for midterm rentals in this area, particularly from military personnel at nearby bases or healthcare workers at local hospitals?

Using round numbers for illustrative purposes. 

Quote from @Franklin Marquette: When building ADUs, do they generally create value uplift for the property in the same way that the main house is valued?

My wife and I moved to main house and rent the guest house as STR What made you interested in investing in this type of deal?

Go to line 4.Since you and your spouse live in Texas, a community property state, you are eligible to treat your 50/50 LLC as a disregarded entity for federal tax purposes.

If not, they may consider building the ADU and down-sizing into it and renting out the main house.

I've been a financial planner for 17+ years and one of the main things I've learned is that the more I think I know what's going on, the less I'm actually correct. 

I definitely agree - not even solving problems like you mentioned - I think its mainly about solving the sellers problem.