When I used a Mac at work .DS_Store files on shared drives were annoying. It meant directories loaded with someone else's preferences about how it should be shown.
Apple apparently has forgotten that it makes Finder, but that should have changed to a .sqlite file in the user’s preferences approximately fifteen years ago. It’s so annoying.
I agree that .DS_Store files getting littered everywhere is a constant menace and that Apple could have solved the problem more elegantly years ago.