In-store pickup is nice in that once it's there, it's there. You can just go grab it at your convenience, instead of dealing with the "can only pickup during this small window" thing UPS does.
Wierd. UPS Delivers to my door only when I am at work. Then, if I don't want to/can't take time off, they tell me I must pick it up between 7 and 9 pm, as those are the only acceptable times, unless I call and arrange a pickup at the office instead of a delivery. If I am really lucky, when I call and arrange for a pickup, they will actually keep it in the office, and won't send it out on the next day's truck. After 3 attempts at this, they return it to sender.
I guess you don't live somewhere interesting and/or don't leave the house.