Add overridable metadata engine creation hooks in `settings.py` (#62184)

https://github.com/apache/airflow/commit/85ccf1accf2aca3f09020bafc2557958de698b53