In order 1 being the most annoying.
5) Collector achievements: Crackdown is a good example of why these are annoying.
4) Multiplayer winstreak achievements: 10 wins in a row. You lose your 10th game. Shoot self.
3) Press start achievements: Soul Calibur 4 and Simpsons I know have these 'achievements'. Not sure about any other titles. They're a waste of space.
2) Play with developer achievements: Arghhhhhhhhhhhhhhhhhhhh.
1) DLC achievements: My once 1000/1000 is no longer 100%. >