It has both positive and negative connotations depending on the context. For an example of the former, look at the lyrics to the Beatles’ Hey Jude. It’s been used that way since 1968!