Competition of Superconductivity and Charge Density Waves in Cuprates: Recent Evidence and Interpretation