One of my closest friends from high school has absence seizures (petite mal is the outdated name). If you tried to put an NPA in her nose she probably would have punched you when she came out of it.
One of the things with absence seizures is that they tend not to last very long, and I personally will only treat if they don't resolve after some time. If it doesn't resolve within a short time frame, I start to suspect it is a complex partial seizure and not an absence seizure. The absence of visible "twitching" doesn't necessarily make it an absence seizure, since they may be having motor activity that isn't visible to you. Something like their eyes jerking to one side, their mouth opening and closing, or something internal like intestinal spasms.
I wouldn't have used an NPA or O2 on this patient, unless I was using oxygen for some other issue and not the seizure.
So, to answer your question. I only use NPAs when I need a short term airway in a patient I think might have a gag reflex. Overdoses are the main situation that comes to mind, and also status generalized seizures with respiratory impairment, and maybe some sort of facial (lower jaw) trauma, but it really depends.