You literally described my life, I wouldn’t have made a better summary.

If you have not already done it and can afford it, I’d suggest you buy a running drinking fountain for him. Many cats prefer running water and, if that need is fulfilled, your cat may be less frustrated by the closed faucet / you may be able to reopen it. (You could, in addition, change the faucet to one that cats cannot open).