Poor guy and poor parents. Maybe something has caused him to be scared to sleep in his room and he may not even be able to verbalize what it is.
A couple of thoughts come to my mind.
Check out Developmental Therapy Associates (DTA) in Cary or Raleigh and get a complete evaluation from them and see what kind of therapies they think might help. He might have a sensory integration dysfunction that causes him to be distraught over sleeping alone. Weighted blankets might help.
Check out ADHD yahoo groups and get ideas/support from a bunch of moms with experience in this area.
Avoid red food coloring in his diet as that makes my son and many others to become hyper and emotional.
Oh, I forgot to recommend Emotional Freedom Technique (EFT). It can be very calming for kids especially.
http://www.newagefast.com/EFT-emotional_freedom_technique...
http://www.emofree.com/ - has free video and manual
http://www.tapping.com/ - offers a great free cheatsheet
http://www.newagefast.com/EFT-test-anxiety-sleep-own-bed....
http://search.emofree.com/search?q=children&entqr=0&a...
http://search.emofree.com/search?q=children+anxiety+sleep...
Good luck.