John Candy was reportedly only paid $414 for his cameo in 'Home Alone' and the film's director said he always felt bitter about it