I don't completely understand this list. It's obviously not just "anything without a roll to work" (no buffs, Identify, etc), and the title "Save or Just Suck" implies a certain kind of spell; but you also include things like Alarm.
EDIT: Also, you have Dispel Magic and some of its variants on the list. It's not an attack roll, but you also specifically list CL checks as something not to include.