I think maybe you could try to use common terminology first.
Bed leveling, whether manual or automatic and Auto Z height adjustment are 2 different things. Look at it from the perspective of getting the bed to seem (or actually be), completely level using the knobs and springs of the bed. This assumes that the bed itself is truly level, (Even though we know from practice that the bed is actually warped due to uneven heat distribution, etc).
Z height offset adjustment is the FINE adjustment for EACH bed surface, filament type combo that we will be using. As an example I have several double sided PEI sheets for my printers. I intentionally flip the plates over for each print when in production. I have at least 1 Z offset for each plate/filament combo. As filaments act differently and I wish to use the SAME GCODE for the filaments to be able to print continuously. (BTW, That's not just filament types like PLA or PETG but brands, colors, and batches. They all can be different).
All that said. Get the manual settings for your bed correct and lock the springs in place. They should be near the MIDDLE of the physical range so that the Z offsets can move either up or down for each build plate/filament combo. If that means that you need to move the Z end stop on your printer than that is what is necessary. Remember the Z offset is only supposed to be +/- 2mm or so.
I hope that helps.