Both openings are terrific, but the 2009 one was more emotionally powerful. It's also nostalgic because it sold me on the idea that Abrams' Trek would work.
STiD, on the other hand, was tremendously fun and very reminiscent of TOS when the team went on wacky adventures, only with a higher budget and higher stakes this time. I was concerned about STiD being a good movie too, but watching that first scene immediately reacquainted me with the movie and I sat relieved, thinking "This is Star Trek, alright!"