DOC: Modified docstring of DataFrame.to_dict() to make the usage of orient='records' more clear
Modified documentation for parameter `index` as is mentioned in #56483.
However, I don't think this should be the final solution to this issue. The current behavior remains counter-intuitive and will confuse users who haven't checked the doc.

closes #56483
Thanks @Huanghz2001 