Only games I've gone to the midnight launches were MW3 and Black Ops.
Black Ops was really fun... just a bunch of dudes, waiting outside of gamestop... Actually no. It was freezing and I was at the end of the line.
MW3 was a lot better, because I was inside a place waiting, and the employees set up Xbox and PS3 systems, with the game in it, so we could play while we waited.