Definitely a struggle.  Sometimes as client  I've also  cursed research results for killing what I/we saw as big impactful ideas. But ultimately research keeps us honest and  asks the only people who matter in the end, those that buy our brands. Flawed maybe ,but necessary.