I have had four seizures in my life, first one when I was 9 yrs old and the last one 2 wks ago at 32 yrs. old. For a few minutes before the seizure I feel very disoriented, confused. It is definitely a scary feeling. In may case, each time an ambulance has been called (cracked my head open twice when I fell), and I usually do not come around until I am in the ambulance. For me, the scary part is trying to remember, what people where saying to me, what if anything did I say to them. The fact that I completely do not remember about 30 min scares me. It's scary when you start coming around and the EMT's are asking you what your name is, what day it is, ect. and it is difficult to wrap your brain around what is going on.
As far as seizures being painful, I would have to say no. Although this last one was a grand mal, for a few days afterward my legs, arms were very sore. Hope this helped :)