Is it worth it to overpay for "missing pieces"?

I feel like teams get too caught up in chasing that one specific veteran to fix a roster hole, even if the contract is absolute madness. Sometimes a long-term commitment to a specialist just ends up being a massive anchor for your cap space later on. Do you think these massive veteran deals are actually worth the risk?