Actually, it means that you live in the middle of nowhere - in the boonies - out in the boondocks - in an extremely rural or out-of-the-way area. Destination has nothing to do with it.
If the nearest place to buy gas for your car is an hour's drive away, you live in bumfuckegypt!
Places such as Phelan, Oak Hills, Pinon Hills, Baldy Mesa,Barstow, Pearblossum, llano, and Adelanto California.
Since i was 2, i have lived in bumfuck capital. No way in hell i'll raise a family here.
My friend moved to the high desert a few years ago. He hates it there. I don't blame him at all. The day he moved, he shouted out the window of his car as he was drove away saying "GOOD BYE BUMBFUCK PHELAN!!!"