Correctly designed, tested, manufactured, fitted and adjusted, a rear wing can do many useful things, including
reducing drag. From PPC's article on the E3 CSL, the addition in 1973 of lots of aero gear including a huge rear spoiler cut drag by 16% as well as giving positive downforce.
In fact, that's what the spoilers on most production cars are for, notably the "Heckspoiler" fitted to many E30s - reducing drag by 'spoiling' the airflow over the bootlid and creating turbulence behind the car.
UweM3 is correct in noting that you'll need to balance it with (ideally) a splitter at the front.
Oh, and the Halfrauds chavtastic spoilers? Well, they look like that because they ape the designs used on racing saloons, so fitted properly they should actually give some downforce - if they stay in one piece and on the car
