If nobody came up with it before:
BOOM, HEADSHOT!!!: Get your first headshot kill with the Sniper Rifle.
Goodbye, Scaramanga: Kill someone who is holding the Golden Gun using the PP7 (when it only has one bullet left)
AAAAAAHHHHHH!!!: Fall to your death on any map.
Poor Baby: Fall to your death on ge_cradle.
Not So Invincible: Get killed within 10 seconds of achieving "I AM INVINCIBLE!"
Hello, 002.: Get killed by a headshot with a Golden Gun (see the beginning scene of The Man With The Golden Gun)
Overachiever/The Ultimate Agent/True 00 Agent: Achieve all other achievements.
Stupid Midget/NikNak Attack: Get killed with a knife after your killer has fallen to a spot nearby you or on top of you.