Fix value_counts for sort=False parameter
- [x] closes #55224 
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [ ] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- [x] Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [ ] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

It appears that `sort` is ignored for many dtypes. Two questions here:

 1. Are we in favor of implementing `sort` here across the board?
 2. Are we okay with adding a do-nothing `sort` argument to some dtypes and implementing fully in future PRs?

My answer to both is "yes", but wanted to get some other eyes on this.

cc @mroeschke @phofl This pull request is stale because it has been open for thirty days with no activity. Please [update](https://pandas.pydata.org/pandas-docs/stable/development/contributing.html#updating-your-pull-request) and respond to this comment if you're still interested in working on this. Hi @rhshadrach, Any suggestions for me to improve the PR? @tirth-hihoriya - adding a `sort` argument that gets ignored for various array types isn't great. I think if these were implemented, we'd be good here. Thanks for the pull request, but it appears to have gone stale. If interested in continuing, please merge in the main branch, address any review comments and/or failing tests, and we can reopen.