Completely agree (with the OP)!
When I play golf with my wife I tee off from the “Forward” tees with her - I’m not a long bomber, anyway, and yeah I enjoy trying to put my tee shot into a position where I … at my current ability level … have a chance of making a good approach shot (Par 4s).
Another method on tee box selection is to look at Par 3 lengths - if you’re not comfortable hitting to a green, say, 200 yards away then you may be better off moving up to the tee where it’s, say, 150.