A number of games over the years have had that. The only one I witnessed myself (and feel is was more the console release) was Halo. I attended a midnight launch and that was just crazy. I was also working for a retailer at the time of the original Modern Warfare launch which was pretty hectic. We had some people that had be queuing for nearly 7 hours.
Others have been the release of the Wii and the PlayStation 3 which I was also present for.
After the Xbox escapade, I vowed never to bother with those releases but just ended up working for a retailer where it was part of my job.