So, when does eventual consistency turn into a real pain in actual apps?

Hey everyone, I'm digging into consistency models for a new project, and eventual consistency keeps coming up. It looks great for high availability and scalability, especially with distributed systems. But I'm curious about how it plays out in real life. Are there times when eventual consistency, even with all its good points, just makes things too messy? I'm talking about problems beyond the clear "we need strong consistency here" situations. What are some of the less obvious issues or operational pains you've run into when using eventual consistency in a live system? I'm trying to figure out when it goes from a clever design to something that causes bugs and annoys users. Any stories or tips on when to really pause before going that route would be super helpful!