Oh god, Brian's Song makes me cry so much (the original, anyway, the recent remake was crap, the actors had no screen presence). Old Yeller is another one that turns on the waterworks.
Other movies that make me tear up, if not outright cry, are Bladerunner (the roof scene), Casablanca, and...