rocksdb creates LOCK and LOG files even if DB does not exist, and create_if_missing is false

### Expected behavior
If `create_if_missing` is false, and we point rocksdb to open some non-sense location such as `/etc`, rocksdb should fail to open the directory, without modifying anything inside said directory.

### Actual behavior
rocksdb adds files like `LOCK`, `LOG` into the directory.

Start by reviewing the linked pull request #5819 and reproducing the issue with create_if_missing set to false against a directory such as /etc. Done means opening a nonexistent database path fails without creating LOCK or LOG files, with tests covering that behavior.

Written by the indexing model from the issue text.