A sysctl.d override is not decided by directory priority alone. The loader first chooses one file when the same filename exists in several supported directories. It then sorts every surviving .conf file lexically and applies assignments in that order. The last surviving assignment for a key wins.
That ...