George Jardine (a Lightroom export) wrote A Few Thoughts on Time Stamps, how he manages time stamps and deal with timezones.
It is a personal thing, and my personal choice is using UTC in the camera and timezone in the library to have the local time (local to the location of the picture). This raise a problem in Ligthroom, but it works in Aperture. And it matches with geo tagging using GPS traces.