There was a pretty good article on all this in a major car mag a while back, where they interviewed factory designers, wind tunnel experts, etc. They found that most rear spoilers are put on factory cars because the sales department wants them. And then the designers focus on making sure the things don't HURT the car's aerodynamics.
On the other hand, a little rear spoiler like the GN's may reduce aerodynamic drag. It won't provide meaningful downforce, but it will help the car move through the air more cleanly by reducing turbulence behind the car (which might explain the "dirty" vs. "clean" effect noted above). Some do help prevent lift at high speeds. An example is the Audi TT, which originally came without a rear spoiler, then the factory recalled them to install a little rear lip to keep the ass from lifting at speed and causing morons to spin their cars.
Front spoilers are more helpful at everyday speeds. I've read that a good front spoiler or "air dam" can have a worthwhile effect at speeds as low as 30 mph by reducing drag and keeping some air out from under the "dirty" bottom of a car. This helps "suck" the car onto the pavement and improve cornering.