Prometheus, I think that the aura you describe is not uncommon with people who suffer from classic migraine attacks, but perhaps you are unusual and lucky in finding it pleasurable! (although I guess the headache itself is no fun).
Me, from about age 8 for approx. 30 years I suffered from classical migraine attacks.These were always preceded by a visual aura; bright flashing lights , shimmering around objects, and a large blind spot to one side of my visual field. I found these auras very distressing, not just because of the blind spot and visual distortion, but because I knew they would be followed by several hours of intense pain and vomiting. At age 38 I suffered a subarachnoid (brain) haemorrhage caused by a ruptured aneurysm ...apparently I had been born with a malformation of blood vessels, previously unrecognised. To cut a long story short I had surgery to mend the damaged blood vessels.... and lo! The migraine attacks disppeared! Well, almost. Since that time I have had practically no headaches, and none of the dreadful one-sided migraines at all; but I do occasionally have the visual disturbance, but with no pain. Unfortunately, even though it is painless, I still find it distressing as it reminds me of being very ill in hospital (before my operation I had a lot of visual disturbance) I have actually seen a suggestion that low blood sugar levels can trigger migraines But I am not sure if this has been researched.
As you have indicated, migraine is said to be related to epilepsy .... both involve changes in (electrical) brain activity. So please , if you are having brief attacks - which could be small seizures or 'petit mal' - consider being checked out by your doctor. These can be controlled, but if neglected, could make driving dangerous. fter my operation, because of the possibility of having a seizure, I was not supposed to drive for a year so I know how frustrating this can be!
Although in my case it appears the migraine headaches were related to the blood vessel malformation, I should stress that my doctor said this is unusual. With most migraine sufferers there is sadly no obvious cause for what can be a very painful and repeated complaint.
Glenn