So, when should you actually use CQRS?

hey everyone, i've been thinking about Command Query Responsibility Segregation (CQRS) lately. it seems like a good fit for systems where reads and writes have different needs, like busy e-commerce sites. but i'm wondering about the practicalities. when have you found CQRS to be a clear win, and what were the trade-offs you ran into? is it usually worth the extra complexity for most apps, or is it more of a niche pattern