when do you actually need a NoSQL database

hey everyone, ive been working on a few projects lately and the topic of NoSQL databases keeps popping up. we're currently using a traditional relational database for everything, and it's been fine. but im starting to wonder, at what point does the rigidity of SQL become a bottleneck? when have you found yourself needing to switch gears and explore options like document stores, key-value pairs, or graph databases? what were the specific pain points with your relational setup that pushed you towards NoSQL?