During his glorious playing career, Danny McGuire was synonymous with success after helping Leeds Rhinos to eight Super League titles and plenty more beside.