From my experience, none of the +++ rated double beds will cause this moodlet. Also, any twin bed that has a corresponding double bed style with a +++ rating does not seem to cause it, either, even though they are only rated ++. Also, I have never seen the Vampiric Slumber bed cause this glitch.
This glitch appears to be linked to the "Well Rested" moodlet somehow. In games where my sims could not afford a good bed right away, I would cancel the sleep action before they were fully rested and their mood would not be affected (doing so would result in the "Bad Night's Sleep" moodlet, though). However, since this glitch does not seem to happen every time a sim sleeps, this may very well just be a coincidence.