Hi Joe, I'm also exploring this question. For now, I am adopting this practical approach: "if I can fly upwind in P mode, then I'm good to go, and if it is windy or gusty, I am careful to fly upwind first!" I like this approach, because it tests the reality on the day, which, as others have mentioned can differ hugely from the forecast, and between altitudes. I have been able to fly upwind and automatically hold position fine in P mode in winds purporting to be gusting to 30mph. On the one occasion (so far - as I'm not massively experienced compared to some) that I immediately started to get sent backwards by the wind - I just switched to S mode, flew myself home, and gave up for the day.
I'm not inclined to carry on flying when I need to place reliance on the extra wind-fighting power of Sport mode: that's because, (if I have understood correctly) the RTH functionality (by whichever means it is engaged) will only fly the drone to P-mode performance levels.