No example is coming to mind where I was really happy about making essentially a copy of a character from some other media, thinly changing it (e.g. changing name and hair color and adapting equipment or other minor changes) and using it in an RPG, either when I did it, or when someone else did. I find it has too much input from the original, that doesn't make complete sense in the game world, and is more or less weird. The more people are aware of it, the worse that feeling is, for me. I have seen some players not mind or even seem to enjoy the "joke" or riff aspect, which I can also appreciate, but the weirdness just seems wrong in a way that's more important to me than the humor, unless it's a one-session game rather than a game world that I want to keep playing in, because I like my game worlds to be self-consistent. I don't want intrusions from copies of TV or even Shakespeare being the reason why some character is the way they are.
For example, I tried making a couple of NPC's based on Butch Cassidy and the Sundance Kid, just changing the names and putting them in a medieval fantasy RPG, so they needed to use crossbows rather than pistols. I gave them crazy skills, and even drew wanted posters of them which were obviously me drawing faces like Paul Newman and Robert Redford. They were also bad because they would have likely easily and too-quickly killed any PC's who got in their way. I'm still embarrassed enough I almost didn't admit it here! Fortunately, I was embarrassed enough to realize it was a bad idea, and never actually used them in play, and decided they didn't exist or would be changed to be two appropriate bandits with nothing like the original film characters except they were a pair of dangerous wanted bandits.
That said, I do think that limited aspects of some known characters can be used in RPG characters without being illogical or weird at all. For me, as long as it is a rational character in the game world, who happens to have some trait that is like some character from some other media, but in a way that makes sense, then it tends to be fine.
For example, I made an NPC who was partly inspired by Indiana Jones. He carried a whip and rope and was athletic, liked exploring interesting places more than fighting, and would try unconventional approaches and wasn't really a front-line fighter. But he wasn't ridiculously skillful, didn't look like Harrison Ford, had a very different personality, wasn't really like Indiana Jones in any other ways, and ended up being a pretty unique and interesting, likeable NPC.
I can think of more subtle examples too, but the above two seem like good illustrative examples.
I can think of a few RPG sessions that used film characters well, but they used the actual character, in amusing ways, and that did still mess with the game world to have them exist in it, but they were settings which saw limited use, the use of those characters was part of the theme, and they were funny about it in a consistent way.