In the first book, Paton goes into this after his disastrous date with Miss Ingledew.
Paton also goes through this in the third book when Ms Ingledew is dying from wearing a bewitched belt. The look on his face when he realises he can't save her is heart-wrenching. Luckily Charlie and his wand are able to revive Ms Ingledew.
There is also another one in the same book when Paton is ill from whatever Yorath did to him in Yewbeam Castle.
Amy seems to go through this for a moment at the end of Hidden King, after Manfred smashes the bottle of King's tears onto the floor to stop Charlie from awakening his father.
Manfred Bloor passes this when he hypnotises Emma Tolly and Lyell Bone, making them forget all their memories.
Yolanda gets this in the third book when she hypnotises Mr Boldova and wipes away all his memories.
Ship Tease: Emma/Charlie in the third book, until Emma's found to have a crush on Tancred. Also Charlie/Olivia.
There's a hugeShip Tease between Henry and Ankaret in Henry and the Guardians of the Lost.
The Untwist: Seriously, is there anyone who didn't guess that Mr. Pilgrim was Charlie's father?
The Woobie: Billy Raven has this hard. Each book introduces some new torment that the poor kid has to go through.
Lyell could also count, in a way, but more in backstory than in the actual series. His father died when he was a baby, and his mother was a complete Jerkass who probably neglected him emotionally once she realised he wasn't endowed in the way she wanted him to be. He spent a good part of his childhood surrounded by nasty, cold-hearted relatives such as Yolanda and the Aunts, and judging from how terrible a sitter Aunt Eustacia was, one can guess how he was treated. On top of all that, his mother held a grudge against him because of a will and a letter his father wrote to him. He falls in love and wishes to marry, but the Yewbeams don't approve and forbid it. He elopes anyway, earning the ire of the entire Yewbeam family. Then, after just four years married and with a two-year-old kid, he gets hypnotised for life when he tries to stop the abduction of Emma Tolly and spends the next ten years in a deep trance, unable to remember anything about his old life. In the fifth book, when he's close to awakening, he almost dies because Harken bewitches Amy into forgetting him, and all because the Bloors and Titania don't want him to wake up and remember where he put the box that contains Maybelle's will. Even after his awakening, Lyell is still not completely himself again, with parts of his memory still missing. Though he does eventually regain all of his memories at the very end of the series.
Emma Tolly was abducted and hypnotised as a baby, and lived a dull and unhappy life for eight years with neglectful foster parents. When she finally wakes up from her trance, she cries and says that she never knew how unhappy she was, and that she lived with people who didn't love her. The happiness in her life only starts when she goes to live with Miss Ingledew in Ingledew's Bookshop.
Paton. His mother was murdered by Yolanda in Yewbeam Castle when Paton was only seven years old; his sisters turned to evil at the same time. His endowment made him a pariah in society and his own family, as he couldn't go outside in daylight. Also because of his endowment he's pretty much a loner, as not many people are brave enough to befriend him. His only friend Lyell disappeared under mysterious circumstances in 1994, and Paton blames himself for it because he didn't meet Lyell when Lyell asked him to. Paton meets a nice lady who he really loves, and who loves him back, but something always seems to crop up to stop them from progressing their relationship into something more.