I'm sorry, I thought this was Mothering Dot Com, not Only-For-Perfect-Parents Dot Com. I think one or two of you are in the wrong place!
LDSmama, here are my thoughts...
I have an extremely emotionally sensitive 9 year old. If something hurts her feelings, she will oftentimes let it snowball to a two hour crying jag at night. She simply can't help it. This happens especially if she gets overly tired. She says she starts thinking of all the bad things that has ever happened to her, and she just gets so sad she can't do anything but cry. No amount of comfort, in any form, helps. If we try to comfort her by telling her all the good things that have happened to her, all the wonderful things we love about her, she just gets more upset. We can't physically lay down with her, as she has the top bunk and we would exceed the weight limit...
Oftentimes the only thing that works is to completely forget about bedtime (which is hard, since she shares a room with her younger sister, who will of course howl about how unfair it is the older one gets to get back up...). We give her papaya enzymes and acidophilus for her tummy (because if she cries so long, she always gets a stomach ache), and tummy mint or sleepy time tea. We tell her to go lay down in our bed, and depending upon what she wants, either one of us lays down with her, or we watch a movie with her. Sometimes she wants to take a bath with lavendar bath salts, so I will draw the bath, and then while she is in there (reading, usually) I will make her some sort of tea. Usually she calms down pretty quickly and goes to sleep then.
With our dd, it is totally hormonal/emotional. She can't even really articulate why she is freaking out. She herself oftentimes says she doesn't know why she is sad or scared or worried, and usually she has no idea what triggered it (other than being overly tired). She just is. It is extremely frustrating at times, and I can't imagine how completely frustrating it would be every night for two weeks in a row!
I second the idea of bringing someone else in. Why don't you sit down with her during the day, and ask her if she woudl like to talk to someone else about her night fears? Would she like to see the doctor; but don't make it out as if she is sick; rather tel her that alot of people go to the doctor to talk about their concerns and fears, and that doctors can be really good listeners. Then call the doc ahead of time and let them know what is going on, and that you expect the doc to be a good listener! If you have a ped who sucks at listening, though, I wouldn't even go this route.
Come up with some ideas about how to help her, and present them to her. Would a new sleeping arrangement help? Would a light help? Our kids have their own little battery operated lanterns in each bed; they don't shed light all over the room, but sort of emit a warm, contained glow. So if one girl has her light on, the other isn't disturbed by it. Would painting the room a different color help? Putting a lock on the closet door? Sleeping with the door open? Going to sleep in your bed, then being moved to her own bed? Sleeping with a sister, in the same bed? Sleeping in a sleeping bag on the floor of your room? Hanging a dream catcher near her bed? Having someone come and bless her room and her bed?
Good luck. I hope you can get to the bottom of this soon. In the mean time, I second the idea that you must get some sleep! Have a friend or grandma come over and watch the kids, put some ear plugs in, and get some sleep!
Let us know how it's going! Keep up the good work!