The only console launch I ever participated in was the Game Boy Advance launch in Japan. I was in Tokyo for TGS, and I don't even know if it was first day or not (doubt it), but I stood in line at Laox in Akihabara for like an hour waiting to buy one.
They only let you buy one at a time, so I got back in line again to buy one for my friend. I ventured to another store that had them, and thankfully, no line there, and they even had the Milky Blue color there (Laox only had them in white and purple by the time I got to the front of the line).
I loved it, though. Despite the non-lit screen, playing F-Zero Advance, SMB2, Kuru Kuru Kururin, and Konami Wai Wai Racing on that system was awesome. The SNES was one of my favorite systems of all-time, so I had to have the GBA ASAP. Since then, though, I've bought an SP, the newly backlit SP, and the DS.
Screen quality aside, the weight and landscape form factor of the original GBA is still my favorite.