I think you guys should stop going off topic, especially with the spoiling.
Now for what I came here for...
Ai Yori Aoshi
Akane-iro ni Somaru SakaKimikiss pure rouge
Lamune
RahXephon
True Tears
Not many have the fantasy or magic, but I the childhood friend is threatened. What sucks is this is a specific request and is going to ruin a lot of the fun.