Lots of scenes in FFIX made me feel that way, but the very ending and one particular scene involving black mages near the end particularly made me really emotional.
Oh, and since someone already went into anime territory: Grave of the Fireflies is probably the most emotional I've ever been in my life.