You always need to adjust the spin based on the wind.
Personally, to gain more distance off the tee, I use backspin with a tailwind, and I go for topspin when facing a headwind.
The key is there isn't a single 'best' spin, it's all about adjusting the type & amount depending on the situation.