It does depend on the kind of a seizure, when/where it happens, how long it lasts, and what shape you were in at the onset of the seizure (i.e. if you were sick, dehydrated, hungry, etc.). Generally if there's been partial or total loss of consciousness, then there's confusion once the seizure's over. A tonic-clonic (grand mal) seizure can be physically exhausting as well, and it's not unusual to feel nauseous and want to sleep/rest for at least a few hours after one occurs. In some cases a person may seem to start snoring loudly following a seizure, before coming to. This just shows that the person is beginning to breathe properly (and does not mean he or she is suffocating).
My seizures have all been tonic-clonics, so I don't know how extensive the confusion can be for other kinds. I do know it varies a lot for me. I've had conversations with other folks after coming out of a tonic-clonic even though I'm not fully conscious or responsive. It may seem that I'm alert, but I may not remember the conversation, and my answers/comments may have no basis in reality. (It's a bit like having a conversation with someone who's sleepwalking). I've had a seizure where I dislocated my shoulder and was walking around with it dislocated -- having no idea why my arm hurt, or that something might have happened to cause it. I had a seizure when I was on the phone with a friend. She could tell what happened, and drove round to see me. I didn't know that anything had happened until she arrived, and then I saw that the phone was off the hook and on the floor. I had a seizure where I cut my leg when I kicked a glass cabinet. I "came to" in the laundry room of my house, apparently I had wandered downstairs while still "half-awake", probably in search of a cloth to clean up the bloody mess. Sometimes the confusion has gone away fairly quickly, other times I've felt foggy and "not myself" for a few weeks.