Agreed. Until there is a setting that allows Obsidian to warn you when you are creating a note with a name that already exists in another folder, I use this and another method to double check that no note already exists with the same name (see Warning: Note with same name exists in another folder). And, like you said, the autocomplete is definitely not one to easily back down.
Thanks.