FWD is great in the snow, but that's about all I can think of that it excels at.
RWD is great in a sports car or truck as upon acceleration, the weight rolls to the rear tires.
AWD is great on slippery surfaces, but it's expensive, heavy, and reduces gas mileage.