cult hero

noun1

1. •
   A public figure who is popular despite limited success and/or talent.

   • Cult hero Matt Spangher, a shaggy-haired journeyman drafted in 2005 who this weekend enjoyed his first grand final, received the biggest cheer. — 2014