Well maybe if we knew where you from people around you could offer opinions... If you mean chain-wise (like gamestop, EB, ect..) it still kinda varies by store.
Personally i've been on all ends of the spectrum for this, some GS will stay open late to let you pick it up at 12:01 (normally the ones outside of malls >.>), some wont have it for a couple days after the release/ship date (since most release dates are actually ship dates when the game is shipped via overnight delivery to stores), some have managers who go wait for the UPS or w/e plane to come into the airport and take it there then rush it to the store.