Most depictions I've come across - and having been given opiates in medical situations - allude to it being like a dream-state. A bit of euphoria. Feeling so good you don't want to move. Hence the attraction for repeating the experience.