I've been a hiring manager for 5 years and otherwise doing candidate screening for 10+ years. Looking back I don't think a cover letter has played a positive role in getting a candidate through, but probably has played a negative role a few times due to typos etc.