I'll try to keep this short, but the original question is very open ended.
First answer is a question: What are you doing with the car?
Drifting: RWD wins hands down unless you are a crazy Finnish dude with an Audi 90 quattro painted like the General Lee (Bing it
)
Everything else: AWD wins, but there's a caveat. Audi showed up in the early 80's with the first rendition of quattro in rally and dominated Group B. When Group B was axed, they went road racing with IMSA and the SCCA Trans AM series in the late 80's and early 90's. Again, they dominated, were penalized with lots of weight, continued to dominate, and were subsequently banned. This happened again in the BTCC (British Touring Car Championship) with the Audi A4's in the late 90's.
Special Applications: FWD has its place and can have advantages, but the next summary will explain why it is least desirable.
Mother Nature, physics, and the friction circle: Your tire's contact patches are your vehicles only attachment to the road. They can only be expected to do so much at any given point in time. They can be used for braking, accelerating, and turning; but asking them to do more than one at the same time is where it gets fun.
This is where RWD and AWD have their advantages. In RWD the front tires are along for the ride most of the time and are really only asked to work under braking and turning. In AWD all the tires share the work in a hippie commune permaculture sustainability kumbaya (sp) kind of way. With FWD, the front tires are the b1tch a33 nizzle doing all the accelerating, braking, and most of the turning.
Unless you are driving an extremely light original Mini in the Monte Carlo Rally of 1966, FWD is not the ringer for top level motorsports. That is why sanctioning bodies like the SCCA cater to different people and different cars.
:banana:
Edit: It's Friday and I'm about to start the second six pack, so if this doesn't make sense or is a little over the top, my bad.