Same issue here: spotlight not working for months now. We tried ALL the "solutions" listed here (folders, powershell, terminal, etc.), still not working.
It's microsoft as usual: complex, inefficient and no support. We also had an issue with onedrive not working any more, supposedly because our profile was corrupt... ?!... even though we didn't do anything specific... !? Not to mention the fact ms won't support windows 10 any more (we have 11 but our parents have 10 and cannot upgrade, they're stuck).
We had a Mac previously, was working fine for more than 10 years, never an issue. The only reason we changed is the excel macros weren't working properly between Mac office and ms from work. We regret now.