One of the better door sounds I've heard recently are in the Subaru cars.
One of the less good are in my Miata, they didn't want to waste even a few ounces on any sound deadening. Doesn't matter once you are behind the wheel.
Recent Corvettes have a different sound. Almost like a capsule sealing up. Of course those cars aren't metal.