Why do I have repeated "Are you sure you want to open it?" messages when launching applications?
Solved the problem! The quarantine metadata was not clearing correctly for some reason. I fixed this by doing:

sudo xattr -d com.apple.quarantine /Applications/Coda\ 2.app


Big thanks to Thomas Reed in the Apple discussion forums - Link to answer.