An emotional Rory McIlroy put a year of near misses and personal troubles behind him to win the DP World Tour Championship and his sixth Race to Dubai with a gritty final performance in Dubai.