I have a 4-wheel drive truck, a front wheel drive car and a rear wheel drive classic car.
Four-wheel is fine for dirt or sand, but sucks when turning sharply on concrete or asphalt.
Front wheel is fine, but watch out when you floor it or the torque will make you turn unexpectedly.
Rear wheel is traditional and I prefer it, but feel All-Wheel is probably the best. That is probably my choice for our next car.