I am approaching this post from a different perspective. From what you write, you sound like you might have a condition called Irritible Bowel Syndrome (IBS).
No one really knows what causes IBS; the gut, however, has the largest concentration of neurons outside of the brain. It is not without reason that people feel nervousness and anxiety in their stomachs. And, that is due in part to that flight and fight reflex that we all have. It is postulated that in IBS, that interaction between brain and gut is VERY oversensitive. But no one really knows why IBS happens.
The main signs of IBS are abdominal pain OR discomfort that is relieved by or associated with a bowel movement. There also can be chronic dirrahea or constipation. Abdominal bloating can also occur, as can the feeling that you did not fully defacate when you emptied your bowels. Some people also report white mucous in the stool.
Some report that food and stress can trigger IBS symptoms. Your situation of spicy foods is a prime example. I would reccomend you keep a journal log of what you are doing and eating when you have IBS symptoms. Maybe in that way you could find some way to coorelate cause and effect and so learn to lessen the IBS.
In IBS, nothing wrong can be found in the intestines when they are examined, but clearly a problem exists.
Support groups can also help with emotional support...it can be therapeutic to talk with those who have your condition.
There are many medications that can be used for IBS...including some of the antidepressant medications, antispasmodic medications, and others. Prilosec and Nexium decrease stomach acid, and dont really affect the intestines. They are used more for heartburn and ulcer than they are for IBS.
I suggest a physician visit for diagnosis and evaluation and possible treatment. Here is the Mayo Clinics site on IBS: http://www.mayoclinic.com/health/irritable-bowel-syndrome/DS00106/DSECTION=1
I hope I was able to help you,
If this is indeed IBS, it is because your bowels are overly sensitive and reacting to that spicy food when they should really not. Its not a "sore" per say, as a result. COULD you have a sore on your bowel? Yes, you could...but from what you wrote it doesnt sound likely. Arguments in favor of some lesion or sore do include the fact you seem to feel it in one specific spot, as one would feel a sore. Arguments against a ulcer are the fact it ONLY hurts with spicy food...ulcers would tend to cause pain irregardless of the food eaten, and, people often say the pain of an ulcer lessens with food.
Your symptoms are why I suggest a doctor visit. He/she can do exams to examine the intestine and see if there is a sore, lesion, or any irritation. In the meantime, cut down/eliminate foods that you know cause you pain and discomfort. If there is a sore that will help it heal. But I do suggest a physician exam.
When you see your doctor, he/she may give you prescription medications that can help relax your intestine and help it heal. If it is just provoked by foods though, he or she may say to merely stop eating those foods.