Green_Hilltop: I really don't recommend Magical Diary, I played it when it came out through and through and all those romances are quite unhealthy (one unbelievably so), and more importantly, if you don't want to date certain characters but be just friends with them, they become butthurt. One believably, as he just wants to use you, but the other one just doesn't make sense. Also the game feels very lonely, your friends aren't really your friends much and it's not very long (I think you can finish the game during one evening, esp. if you don't save/reload because of the stat cramming). It starts out good but then falls through, so watch a bit beyond the demo, so you won't get disappoined, esp. if you want something in the tone of Harry Potter, this isn't it. And the atmosphere, like I mentioned, is often very sad and glum.
If you want something happy, this won't be for you, although one route makes the game happier. I might be biased,
but I was very disappointed by this game as it really isn't what I wanted or was expecting after playing the demo, so I felt like the demo sold me on a completely different game and then turned from a 'happy beginnings at the magic school' into a 'depressed, sad and rather lonely in a magic school' game.
Academagia is the way to go if you want a magical school simulator, for anyone interested, and it has about 16 free DLC with more quests, characters and skills. But I'm not sure if it contains a romance.
Well, I actually liked the game because of that. It's not as happy go lucky shallow as it may initially appear, although you should already have been clued in to the game's self-awareness by the default main character's name being "Mary Sue". Abusive relationships are actually something of a running theme in the game and I think the developer went about portaying that in an interesting way. I think I read on the developer's forum that loads of people stumbled into that one romance completely unsuspecting, only realizing they'd entered into an unhealthy relationship a ways into the game. So I think the game is actually pretty good at making you consider those things. But yeah, if you're only looking for a happy ride you won't find it there.