I think it's a fun episode... not great, not awful.... entertaining.
As a sufferer of night terrors, I do probably find it a bit more disturbing than some. Situations like with Riker and the snakes etc. I have many nights every week. Thankfully it could be worse... at least I don't have floating Trois around.