I lived directly behind the loading area for a large grocery store for a few years and personally I thought noise concerns were overblown. After the first week or so I was just used to those noises and slept right through them.

Granted, that might not be something everyone can deal with, but I imagine a lot of people can.

P.S.: It was great having a (24 hour!) grocery store that close. I thought of it as my personal walk-in pantry.