SharePoint folder "modified" date not accurate

Hi Rabarai, thank you for your explanations. However, I would say File Explorer also have some kind of database where it store information like date, time, modifiers. It will be just a different type of database. Well, if SharePoint uses database, controlling metadata is much more flexible and having more features and option, should be able to input such a critical information. File name and keyword and searching is not what we are after, we are after when the folders are displayed, and along with the name of the file/folder, we used to see time stamps which we heavily rely on when dealing with large finance related documents, or Government sensitive data.
The complexity of the situation badly impacted by not having the time stamps when moving/copying a files/folder from one site to another SharePoint site is killing. When migrating from onprem file server to SharePoint online, it was possible to migrate with those time stamps and that was what I did for my work place, so that tells SharePoint has capability to copy metadata from legacy onprem files/folder into modern SharePoint and store it in its metadata.

It is just Microsoft forgot to include such an important and critical service or functionality.
While writing this, I still felt the pain, I just step out from a meeting with our managers talking about this painful situation and making the next plan.