The best Ghostface killers in the franchise are considered to be the original duo, Billy Loomis and Stu Macher, who had deeply personal motives and played with the self-awareness of the horror genre.
In that film, Macher and franchise protagonist Sidney Prescott’s boyfriend Billy Loomis were revealed to be the Ghostface killers, with Sidney killing both characters at the end of the movie.