One of the biggest issues with the MPDG is often the man she's interested in. It's always like... the girl is talented, fun and really extra, and then the guy is just the dullest person to ever live, and she likes him because....errr.......?
This is why the only examples of the trope I really like are:
Scott Pilgrim (but the comics, not Michael Cera's sleepy, low-energy performance) because Scott is a very extra guy; he's in a band, he gets into fights and has exes and baggage of his own. In fact it turns out Scott and Ramona really aren't so different in the end. Scott is convinced he's this happy-go-lucky guy who the world has it out for, but realises that his tendency to just drift through life, always taking and never giving, never considering the consequences of anything he does, is actually hurtful to others. He and Ramona both need to learn to not be so wrapped up in themselves.
Ah My Goddess! Keiichi is the opposite route to Scott Pilgrim in a way, because he is the nicest man alive, but it's appropriate because Scott is a mess on the same level as Ramona, and Keiichi is a noble, self-sacrificing guy who strives to be on the level of literal heavenly being Belldandy. In a moment of desperate loneliness, this reliable, kind-hearted guy everyone takes advantage of, wishes a goddess on the phone was his girlfriend... and now faced with actually having a literal goddess as a girlfriend, he steps up, provides her with a safe home, takes care of money, even welcomes her mischief-causing sisters, and deals with all the magical crap in his life like a champ. When reading or watching Ah My Goddess! I never felt like "What does Belldandy see in this guy?" because Keiichi is just as committed to being fair and kind to others as she is.
For me, the secret ingredient is that even if on the surface the main character seems like "the normal one", they need to meet their partner's energy somehow in a way where you can buy this is a relationship that would work due to shared values and life goals. It tends to work better if "the normal one" turns out to be just as much of a freak under the surface and that the "weird one" was instinctively drawn to that.
Otherwise it's just this boring fantasy scenario somebody has come up with like "what if I made absolutely no effort to do or say anything interesting, present myself nicely, have interesting experiences to talk about or even to go out and interact with women at all, but then a woman came and found me and she was super hot and nicely presented with cool clothes and said and did loads of cool, interesting things and was way into me just for existing and also made me do cool things so I could do cool things while still maintaining an apathetic facade?"