> nd more than once, it hasn't shown up at all, despite being marked as "delivered at front door". <

It very well might have been delivered, but stolen before you got to it. Super likely in the Bay Area and especially San Francisco.