That's something I struggled with too. Honestly, at first, the price tag of those product information systems scared me away. I was managing (or trying to manage!) everything with spreadsheets. Then I realized how much time I was wasting and how many errors were creeping in, and needed to explore my options. This article helped me consider some possibilities:
https://www.webpronews.com/pim-for-bigcommerce/. Ultimately, I think whether it's worth it depends on the size and complexity of your product catalog, and how much you value your time. I made the plunge, and within a few months, it’s already paying for itself.