That all being said, I really don’t think open concepts or great rooms where the kitchen, living, and dining areas are either wide open or visually connected is going away at all. 

I would look at comps for high durability designs that are still visually attractive. 

Does anyone have an Excel modeler that helps visualize different buy/hold, BRRR and flip partnership structures/returns?

Obviously mounted up high in a readily visible spot "trail cams" work just as well (as a possible visual deterrent), very cheap online. 

You can also drive by the property and perform a visual inspection before the auction date.Look for REO homesIf a home doesn’t sell to a third-party at auction, it becomes a real estate-owned (REO) home.

I like the visual it gives me on a map.

If so, I'd start bringing a tape with me to look at houses if the problem is you can not visualize 30 sq ft of granite.

In addition to that he explained, and the best part for me as I am a bit of a visual learner, he showed how most people's rehab estimates are way off.

Please everyone .. do NOT do thisLet me visualize what you are telling others to do.So logically, this doesn't make sense.

Without visually inspecting the sold comps via photos, you can segregate the renovated from distressed by chunking the $/sf of the resulting comps by quantile groupings.