Oprah Winfrey, Dwayne 'The Rock' Johnson and Tyler Perry are among the role models who have inspired people to push past limitations