All very well ShyTorque if your airport has multiple runways, unfortunately in alot of scenarios this isn't the case.
I just did a little experiment using RANT XL
All tracks show an aircraft climbing at 75kts, and had the engine failure 1 minute 5 seconds after the upwind end of the runway.
Yellow line wind = 270/25
Red line wind = 270/05
Cyan line wind = 090/05
As we can see any kind of headwind really blows you round the turn. Would I turn back in any of these situations? No way.
Final 3 Greens, I totally agree, landing ahead with a 25kt headwind is more favourable, but I have known (as I'm sure we all have) the wind at circuit height to be considerably stronger than the surface wind.
End of the day you just have to make the best of a very bad situation, and if that means putting the plane on top some trees then so be it