Just in terms of shear momentary joy, I don't think a goal sticks out more than that one for me... mad to think that such elation was followed so quickly by utter gloom.
There are some other goals (usually late in games) from the Moyes era that really stick out in my mind too. Pienaar chip against Arsenal, Gosling in the cup against the RS, Saha in the cup final.... Jelavic's second in that 4-4 against United (paddy power had him at 50-1 for two or more despite having scored 3 braces in a row.... £££££££)