I almost always have <5 such cells in a sheet, typically just 2-3, so I don't think it would be that tedious given you only have to set that once.

In comparison, I often have formulas with over 20 cell references and/or multiple formulas referencing the "constants", so getting asked for each would indeed be tedious.