There are pros and cons for each; certainly the metric names are shorter (and therefore less likely to cause confusion).
For some time, the controlling dimension on many devices has become metric (mm); this is true of parts from connectors to passives to complex integrated circuits and on some devices (Micron memory parts come to mind) the only stated dimensions are in mm (see this part as an example) which tends to push me toward metric units.
Some manufacturers are providing schematic symbol and footprints that use the Ultra Librarian tool which are generally metric in nature. The tool takes a vendor neutral file and can generate the necessary outputs for many different CAD tools.
I would not convert old footprints (they are still perfectly good) and I can only state that I personally use metric formats for new components all the time (for consistency) unless a client specifically requests that I use mils.