It can be positive in the sense you pointed out. It can also be used in a positive or neutral sense to refer to someone being in a very good mood, especially in a bad situation.