Welcome to the board, there is much to learn, and with this condition it will be up to you to know what is best for you. This is perfectly demonstrated by your first lesson here, being prescribed the pills. Usually completely worthless, injections best, nasal sprays second.
BUT... the first thing you should look into is high flow oxygen. Read up on the oxygen info link on the left, then ask questions.
The next thing you will want to do is find a preventative medicine. If going with conventional medicine, you will need to work closely with a Headache Specialist, not just any ordinary doctor, to look at things like Verapamil and Lithium.
If you are open to alternative medicine please visit the sister site clusterbusters.com for more information. This method has been showing amazing results compared with the conventional stuff.
Yes, always keep your hopes up. It is possible to get this under control and have a good life. How fast that happens will depend on you, how aggressively YOU attack this (don't depend on your doctor, read, read, read).
Again welcome, and good reading... wishing you pain free days.

The most important question now: do you have a doc who knows about headache, has experience & skill?
===
Please tell us where you live. Follow the next line to a message which explains why knowing your location and your medical history will help us to help you.

                       CLUSTER HEADACHE HELP AND SUPPORT › GETTING TO KNOW YA › NEWBIES, HELP US...HELP YOU
==================
The med you have is highly effective bu the pill form is too slow acting to counteract the strong, rapid development of Cluster attacks. Injection form is best.

But, you also will benefit from a preventive med which give long term protection by reducing/preventive attacks.

Print the PDF file, below, and use as a tool to discuss options with your doc.
====

Cluster headache.
From: Multimedia File Viewing and Clickable Links are available for Registered Members only!!  You need to or (Orphanet Journal of Rare Diseases)
[Easy to read; one of the better overview articles I've seen. Suggest printing the full length article--link, line above--if you are serious about keeping a good medical library on the subject.]

Leroux E, Ducros A.

ABSTRACT: Cluster headache (CH) is a primary headache disease characterized by recurrent short-lasting attacks (15 to 180 minutes) of excruciating unilateral periorbital pain accompanied by ipsilateral autonomic signs (lacrimation, nasal congestion, ptosis, miosis, lid edema, redness of the eye). It affects young adults, predominantly males. Prevalence is estimated at 0.5-1.0/1,000. CH has a circannual and circadian periodicity, attacks being clustered (hence the name) in bouts that can occur during specific months of the year. ALCOHOL IS THE ONLY DIETARY TRIGGER OF CH, STRONG ODORS (MAINLY SOLVENTS AND CIGARETTE SMOKE) AND NAPPING MAY ALSO TRIGGER CH ATTACKS. During bouts, attacks may happen at precise hours, especially during the night. During the attacks, patients tend to be restless. CH may be episodic or chronic, depending on the presence of remission periods. CH IS ASSOCIATED WITH TRIGEMINOVASCULAR ACTIVATION AND NEUROENDOCRINE AND VEGETATIVE DISTURBANCES, HOWEVER, THE PRECISE CAUSATIVE MECHANISMS REMAIN UNKNOWN. Involvement of the hypothalamus (a structure regulating endocrine function and sleep-wake rhythms) has been confirmed, explaining, at least in part, the cyclic aspects of CH. The disease is familial in about 10% of cases. Genetic factors play a role in CH susceptibility, and a causative role has been suggested for the hypocretin receptor gene. Diagnosis is clinical. Differential diagnoses include other primary headache diseases such as migraine, paroxysmal hemicrania and SUNCT syndrome. At present, there is no curative treatment. There are efficient treatments to shorten the painful attacks (acute treatments) and to reduce the number of daily attacks (prophylactic treatments). Acute treatment is based on subcutaneous administration of sumatriptan and high-flow oxygen. Verapamil, lithium, methysergide, prednisone, greater occipital nerve blocks and topiramate may be used for prophylaxis. In refractory cases, deep-brain stimulation of the hypothalamus and greater occipital nerve stimulators have been tried in experimental settings.THE DISEASE COURSE OVER A LIFETIME IS UNPREDICTABLE. Some patients have only one period of attacks, while in others the disease evolves from episodic to chronic form.

PMID: 18651939 [PubMed]