Connor receives the Prize
As described in the film, Highlander, The Prize consists of all the power of all the Immortals who ever lived. The Prize awaits the one Immortal who accomplishes the daunting task of surviving all his or her fellow Immortals, winning their final bout, and becoming 'The One', thus collecting every quickening.
The exact rewards that come with the Prize are unspecified, but are hinted at and referred to in the movies and series as may be including: the ability to dominate all of mankind, the ability to know what mortals are thinking, the combined quickening energy and experience of all immortals, and the ability to render oneself mortal, thus becoming able to bear children. Because of the implied power of the Prize, Ramirez stated that, "The Kurgan...is the strongest of all the immortals. He's the perfect warrior. If he wins the Prize, mortal man would suffer an eternity of darkness."
Within the film Highlander, upon winning the prize, Connor shouted ecstatically, "I feel everything! I know everything! I am everything!" He would later explain it as being "like a whirlwind in my head. But if I concentrate... I know what people are thinking... all over the world. Presidents... diplomats... scientists. I can help them understand each other." Furthermore, he was now mortal, capable of having children, and that he could grow old and eventually die like everyone else.
MacLeod elected to use the Prize in a more benevolent manner than The Kurgan likely would have, believing humanity should have the blessings of liberty and communicating with the world's greatest minds and leaders to facilitate the cause of world peace.
According to Highlander II, the prize also allows his winner, in the end of his Earthly life, to return to his own time.
In Highlander III, as Connor had already won the prize he physically aged by a few years, although he never had any biological children he adopted John MacLeod with his now wife Brenda Wyatt. It was only after Kane had taken the head of one of his disciples after being freed from is imprisonment that benefits of the prize were removed from Connor making him Immortal once again and the Prize once again a battle for the last two immortals. After finally beheading, Kane the Prize would once again be his and he returned to being mortal.
In Highlander: The Source, the Prize was reinterpreted once again similar to what Juan Sánchez Villa-Lobos Ramírez said that the remaining immortals would be pulled to a far off land to fight for the Prize. Except it is revealed that the Prize was mortality within the "Source" itself and not to fight till there is only one immortal left, but only "One" immortal can enter the source with the purist of hearts to end the fighting and not beheading The Guardian of the Source itself. Thus allowing the new interpretation with Duncan and his mortal wife Anna entered the Source they conceived a child who himself would become immortal but with the ability to have children, where Duncan MacLeod proclaims "He is the one."
Since Highlander: The Source is part of the Highlander: The Series in it's definition of "The Prize" is different to that of the movie continuity and considered an alternate reality or "Bad Dream" Duncan MacLeod had my fans and the producers.
Note: Initially, the film, Highlander, was a stand alone with a definitive conclusion in which Connor MacLeod won the Prize and was the last Immortal. The introduction of the series and subsequent sequels rendered that conclusion fluid, or at least only valid in an alternate time line. Within the series universe, Connor was merely the defeater of the Kurgan, and was not the last man standing.