It's cathartic and validating to be proclaimed as 'special' – whether that involves being named in a prophecy, reincarnated from a dragon, or getting transformed into a super-soldier. For that reason, the 'Chosen One' plot device is very appealing on a personal, archetypal level. Role playing games, in both their tabletop and digital incarnations, are unabashedly a form of wish-fulfillment, a way for people to place themselves in the shoes of characters who are different, exciting, dangerous, and unique. Rarer, but just as interesting, are the RPGs that don't give their protagonists any special edge or narrative weight, forcing them to build their heroic legends and reputations completely from scratch.
Nearly every fantasy RPG franchise on the market, from The Elder Scrolls to Dragon Age, make the main character a 'Chosen One' of some stripe, a hero who's special compared to their companions and enemies.