The truth could also be related to his feelings. Perhaps he's in love with Hermione more deeply than she realizes, and there are some misunderstandings that get cleared up when she finds out. In certain fanfictions, Ron might have been sacrificing his own opportunities for Hermione's sake, like giving up a chance to study with a great wizard so she could go instead.
It might be that the truth is about his own origin and the prophecy associated with him. He could discover that the village had been manipulating him all along based on this prophecy. For example, they might have been using him as a weapon without his full knowledge, and once he finds out, he decides to leave to find his own path away from their control.
One possible consequence could be a shift in the power dynamics within the village he leaves. His departure might leave a void that could be filled by either positive or negative forces. Also, his friends would likely be deeply affected, feeling a sense of loss and perhaps even betrayal.
However, if the truth is something more complicated or even a bit negative, like Ron has been lying about his family's financial situation to seem more worthy of her, it could cause a rift. She might feel betrayed at first, but depending on how Ron explains and if he's truly sorry, they could work through it.
In many 'Batman Beyond' fanfictions where Dana finds out, it could be about her finding out Bruce Wayne is Batman. Maybe she stumbles upon some evidence in the Batcave or notices some similarities in Terry's behavior to Bruce. For example, she might notice Terry's fighting style is similar to what she's heard about Batman's. It could also be that she discovers some secret technology related to Batman that leads her to the truth.
Ginny's reaction could also involve a sense of helplessness at first. But then she'd quickly gather herself and use her resources. For instance, she might call on her friends and family for help. She'd be by Harry's side constantly, using her presence to comfort him and also using her knowledge of magic to try and ease his pain.
For Merlin, there are both good and bad consequences. On the bad side, some of the more traditional and anti - magic people in Camelot might try to oppose him. However, since Arthur now knows, he has a powerful ally. Arthur can protect Merlin from those who would do him harm. Also, Merlin can now be more open about using his magic for the good of Camelot, which is a positive change.
She might be overjoyed. After all, Naruto is her son. She could immediately rush to find him and embrace him tightly, tears of happiness streaming down her face.