Not where I live (which is near Habsburg). I would pronounce it the same as the B in -burg. Where are you from (if you care to answer, no problem if not)
That's interesting, I'm not originally German but went to school in Berlin since I was 7 and always heard it pronounced as "Haaps-burk".
I'd think this is just because of how final obstruent devoicing works in German, to me it just seems like the obvious natural way to pronounce the word.