The question usually arrives as a product name. "Should we move off HubSpot before the sales hire starts?" "Is there a tool for renewals?" Before comparing products, I want to know what the process is supposed to do and where it breaks today. The answer is one of three, and building is the one I recommend least often.
Fix what you have
Often the tool is fine and the process around it is what breaks. HubSpot fills with duplicates because the website form and the founders each create contacts their own way, and the pipeline report ends up as the one only you trust. A Boston nonprofit sailing school I'm working with runs on 16 platforms, including Salesforce, scheduling, payments, assets, and maintenance tracking. The engagement is to cut that sprawl, and the first step is a list of what each platform does and who uses it.
Buy
If an off-the-shelf tool fits most of the process, and the part it doesn't fit can change, buy it. It comes with support and updates, and other customers find the bugs first. An early employer of mine couldn't settle on a CRM and ended up running two: Salesforce, and a custom one an outside consultant built in FileMaker Pro. It worked, and it was probably not cost effective while Salesforce was also being paid for. If buying beats building, that's what I'll recommend.
Build
Build when the process is how you make money and no product fits it, or when the data has to stay yours. An early-stage cybersecurity firm selling to enterprises now tracks renewals for 34 enterprise accounts with a small team, in a system it owns. Each account sits on one page with the contract in force, the signed documents behind it, how the client is billed, and a history of every change that can't be quietly rewritten. The firm's CEO priced a CRM license plus an implementation partner, then chose to own the system instead.
How to tell which
Write down the process as it runs today, exceptions included. Mark the steps a tool would have to handle before your team could stop using the spreadsheet. Then score each product demo against that list, step by step, before anyone on the sales call shows you the dashboard.