Huh, I swear I heard in a positive context before. But English in not my native language, so my feel on the nuance of this expression is probably a bit off.
For example, it would not be out of the question to say something like “when the iPhone launched it was amazing. Like a palm pilot on crack.”
So, when used positively, “on crack” is generally a modifier(in my experience). When used alone it does seem to have negative connotations.