My S7 has occasional nightmares and crawls in bed with me in the middle of the night. He is a kicker and makes it tough for me to sleep at times. D5 never wakes up and probably could sleep through a tornado.
As for the nightmares, I ended up buying them both dream catchers to put over their beds. It did not work for that long. The best thing I use now when S7 has nightmares is to rub some what I call "good dream lotion" on his neck. He believes it works, but I have not told him it is just my mens cologne.