Welcome to icliniq.com.
The nature of pain you described fits into the diagnosis of vascular headache. It merely occurs due to dilation of blood vessels in the scalp and inflammation of perivascular tissues. Although it causes significant discomfort, it is a very benign illness and has nothing to do with psychosis.
It gets aggravated by stress, change in weather, change in atmospheric pressure, intense sunlight, noise, etc. The treatment is simple in most of the cases.
Naproxen 500 mg and Sumatriptan can terminate acute episodes. For prevention of such headaches, a combination of Propranolol and Flunarizine would be helpful. Some people respond better to Topiramate.