Use `db_agnostic` cache profile option instead of fidelity

NOTE: db_agnostic=True means fidelity=False (default)
Cleaned up tests for `db_agnostic` cache profile option
Documented `db_agnostic` option