Anyway, after the second trip, before going on a third, he still didn't think to actually check the complete 'requirements' for his trip to the hardware store. You buy a part for your drill, but don't check if it will fit your drill? Why not bring the drill and then take a picture of the job site, if you are going to ask the people at the store for help anyway.
It's like downloading a compiler, write lot's of code in Python and then being annoyed it's a C++ compiler or whatever. Same for the "not actually extendable hose". Maybe call the wife, or just buy the hose and return it if you don't need it on another trip to the hardware store later that day or week when you pass there. Just painful, no planning or thinking.
The only thing I can imagine just being domain knowledge, is that the spigot needed a hole to be drilled eventhough it has an inlet which I would also assume was open.