POC/ENH: infer resolution in array_to_datetime
xref #55564 implements the relevant logic in array_to_datetime, does not change any user-facing behavior yet.

Have not yet done any profiling, but we have to expect a slowdown.
@mroeschke ok here?  this goes a long way toward #55901 Thanks @jbrockmendel 