UPS just handed my package off to USPS who put a note in my box saying that I could come to a Post Office, wait in a long line, then pick-up my package myself. WTF is this?
It's UPS Surepost. Shippers use it for packages that are price-sensitive but not time-sensitive.
You don't have to go to the post office to pick up the package. You can sign the release, and have them leave it at your door.
SurePost, since he said it originated at UPS.
SmartPost is the competing service from FedEx.
Notice that both of them have the word "Post" in it. Thus, not surprising that they hand off the last mile to the postal service.