I'll second the recommentation for "In the Shadow of the Moon"...many Apollo astronauts are giving their thoughts on things throughout the movie, a lot of very interesting insights. They are a funny bunch too.
Yeah, the astronauts haven't exactly been "mum" about their experiences...
Dave
(To the Moon, produced for NOVA, is another good one...)