pd.to_datetime docstring needs upgrade

[tdpetrou]

Problem description

pd.to_datetime has a very short non-descriptive docstring: Convert argument to datetime.

Using the term datetime is horribly confusing as there is a Python datetime, a NumPy datetime64 and a pandas Timestamp. Although, there is better documentation under the parameters, this needs to be expanded to more than 4 words.

Expected Output

Along with a more thorough explanation, It would be nice if there was consistency with how pandas refers to the triple-headed monster, datetime, datetime64 and Timestamp.

[AdamShamlian]

I'd gladly chip in on the docstring, but I hesitate to contribute a larger handling of "the triple-headed monster." I'd rather leave that to a) another PR against general DOCS and b) someone with much greater context for where pandas has been and where its headed in that regard.

[mroeschke]

Closed by #42494