Winds cannot be estimated from a forecast, no way. For ground speed you'd need a wind meter to come close to a good estimate, as it can vary a lot up high versus down low. Floating in ATTI is an accurate way to measure wind speed at altitude. Wind varies a lot based on altitude, time and intensity of the wind storm you get (story below). You know your drone will do 40+mph in sport mode. That mode is faster than ATTI mode, about 9 to 10mph faster, (33mph versus 43mph) so Sport mode is your best bet for fighting wind. In your case, when you were in sport mode, you likely had a momentary gust of wind, and when you switched to ATTI, the wind subsided, coincidentally, making you think ATTI was best. When you find yourself in this predicament, the best thing to do is get as low to the ground as you feel comfortable and full throttle it back in S mode.
I had some "Santa Ana" winds on Sunday afternoon in Anaheim hills. What a mistake to fly that day. Keep in mind I've flown in 20 to 25mph winds many times before (measured with wind meter), I'm not really afraid of getting my craft back in consistent wind. However, Sunday was a bit scary. I'm out flying in 15mph winds, measured by floating in ATTI mode for 20 seconds. Having a great time running my new 5870mah battery for the first time in my P4. Then.... out of the blue.....all heck broke loose and the wind kicked up while I'm about 3000' away crosswind, so I headed back home. By the time I got home the wind kicked up to 35mph (estimated only by feel), maybe more. It was crazy, it blew my ballcap off. There was no way to land it on the ground without stuffing it into the bushes, way too intense to set it down. I always hand catch anyway, I'm very comfortable with hand catching and very experienced doing it (IMHO). However my craft was bouncing up and down about 1' at a time, randomly to the wind, and the craft was sitting at about a 30 degree pitch just to hover in the same place. This was pretty crazy, something I had never experienced while flying. I was wishing I had gloves on to catch this thing. However, after patiently waiting for the right moment, I grabbed it and everything was good. I had 13% left. whew. I put my tail between my legs and humbly drove home, slow

. I had been shown my flight limits on Sunday.

I haven't reviewed the video yet, that might be interesting at landing.