I think the context I’ve heard it most often is someone fondly recalling a dead friend. “Oh, Louise, she was so opinionated!” wipes away tear
I’m surprised it has a negative connotation.
When used as a pejorative, I typically hear it as “Has an axe to grind”