It ads dimensions to the characters and my players like it. Haven’t you ever tried something monumentally stupid? But if it would just work your wildest fantasies would suddenly become reachable? We make those moments for our characters, too. Hell, I have looped back around to one of these failed attempts at the end of the session and turned it into a solution. (Barb wanted to throw a small fort, at the end got a temporary magic item that allowed them to block a monster-spewing hole with said fort). Its fun. I didn’t even mean for the item to be used in that way when I made it prior to the session.