Fixes #34323 - use defaults from memory

This loads values from database only if the values are in the database.
If there is no value populated for the Setting, we want to read the default from memory.

Fixes #33791 - respect global settings precedence

In the new registry we've forgot to force the global values precedence.
This forces the global values to be respected.

Refs #31059 - cleanup Environment from tests

Removes Environment related notes from tests, mostly just Host being
uselessly provided an environment.

Fixes #30860 - introduce SettingPresenter (#8001)

Introduces SettingPresenter, that should keep all the information about setting.
This aims to keep such information only in the code and remove them from the DB.

This only prepares the ground for future drop of this information from DB....