Both Muv-Luv Alternative's Opening and Ever17's Opening really stood out to me when I read them. I think I watched them every time I started up the games.

Honorable mention to Little Busters' Opening, which didn't really wow me initially but grew on me gradually as I read through it, and now it's my overall favorite opening.