It can be like that, I’ve seen huge queues outside Piccadilly in Manchester. Long enough that I’ve never done it. That said I can’t think of anything I’ve really wanted that I haven’t found later online. Obviously I end up paying shipping, but I prefer that to the queueing and claustrophobia of a rammed store. As mentioned above I’ve found some stuff afterwards that I thought would be long gone, e.g. the signed Ron Carter, a Mugstar album limited to 500 etc.
I stand by what I said upthread that in most cases RSD stuff isn’t limited in any meaningful way, they press whatever they think they can sell into the shops. I certainly don’t view RSD as a good event for speculation, the popular stuff is always a very large pressing number. As an example I bet you could still find a sealed copy of Bowie’s Welcome To The Blackout 3xLP from six years ago for not that much more than the expensive price on the day (it was £45 or £49 IIRC), and that is one of the better RSD titles ever IMHO. They pressed shed-loads of it; Piccadilly had it in stock for months!
I went to Piccadilly once for RSD morning, perhaps 7 years ago. Got there at something like 6am from memory and the queue was already round the other side of the block by then. Tbh I enjoyed it as a one-off, got chatting to a couple of people in the queue, and had the pleasure of going for a coffee afterwards and flicking through the covers of the half dozen records I'd bought (any other time it would be one record at a time). Not been since as there's been very little of interest to me. Piccadilly gets a good stock in but they do tend to a few quid more than some other shops. There are two I'd like this year but whether worth the queues...
Edit: good to see people getting ready early: https://www.ebay.co.uk/itm/27639921...pid=5338728743&customid=&toolid=10001&mkevt=1
This site contains affiliate links for which pink fish media may be compensated.