No, it doesn't happen for everyone. From what I've seen SP is usually not a negative experience for those who seek it out. They'll just be paralyzed and feel some strange (not necessarily unpleasant) sensations with no fear or hallucinations or anything.