Basic cascades, like the ones in OpenCV will not be enough for robust car detection.
However there are more advanced cascade based techniques, like ACF / ICF that will do just fine.
Advantage of using DNN, which can be either YOLO or SSD, is that both techniques contain several off-the-shelf models that contain the car class, and thus we can use the models without retraining anything.