Had similar issues with Jazz basses but, amongst many others, two stand out - both in their own way exceptionally rare and desirable.
I had GAS for a Westone Pantera X790 ever since seeing the page on the interweb about them. I found one for sale in Holland for a premium price and picked it up in person. Had it put back to pretty much museum condition but never ever enjoyed playing it. Didn't like the tone, didn't like the way it hung. Had to admit to myself that it just didn't do it for me. Took a massive hit financially when I finally moved it on.
Copy and paste my latest quest - the Yamaha BB5000 I imported from Japan. Love my BB425 but find it too heavy so this one ticked all the boxes for my dream bass. Nope. Fabulous bass, just not for me. Sold it to someone in Germany and now we are having a potentially punishingly expensive discussion about the amount of trussrod movement.