I think the front spoiler, besides create downforce, can lower the cars drag coefficent because it reduces the air going under the car?

The rear spoiler will create some drag, but the downforce helps keep the rear planted going through high speed curves.

As for newer cars, the Chrysler Crossfire has a spoiler that automatically open from the back of the car at around 55 MPH.