There are sound engineering principles as to why the spoiler could both increase or decrease drag. However the interaction between every minute feature on the vehicle body is so complex that it's really not worth guessing either way without wind tunnel or CFD evidence. E.g. the rear of a car could be shaped brilliantly, only for the turbulent airflow off of a wing mirror to just-so-happen to land in a really bad place and mess everything up. You might think you've noticed that a cup spoiler makes the rear window more dirty & therefore reason that it creates turbulence at that spot. That may well be true, but you have no idea of the overall effect on the vehicle. E.g. canards (dive planes) on a front bumper deliberately cause turbulence (you would normally assume this is bad) in a very strategic place which ends up significantly increasing the performance of a rear diffuser (which far outweighs a little bit of turbulence on the edge of the front bumper)...
P.S. On the weight front no-one can notice 0.01% more weight lol (assuming a 1kg difference to a 1000kg car) even on the roofline.
Literally the only noticeable thing it does is look better.