I also vaguely remember reading about Western games that had very big queues at physical stores during their release. I assume these can only be heavily anticipated old games before online distribution took off. I checked up the wiki articles of Super Mario Bros 3., Super Mario World, Sonic 2, Sonic CD and Mortal Kombat II but saw no direct mention of queues or otherwise remarkable physical activity at stores on release.
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.