A magic moment for me was writing a sorting algorithm that was horrifically inefficient (I think it was like bubble sort but worse), and then later finding out about recursive sorting and making what I now know to be merge sort. It was really special to realize that you can make code that does the same thing but faster if you're clever.