I checked other questions, checked Apple forums - the only thing I could find is Sort by / Arrange by
but in my case none of their combinations helps me to get plain "by name" option, currently I can't even find any logic in how it sorts the files:
Any help is much appreciated. I'm on macOS 10.12.6.