My home course (par 71) is 7160 from the back tees, 6650 from the men's tees, 6100 from the senior tees. I am down to a 1.5 handicap right now and I hit my 5 iron 175. I would say that for my handicap I have average-ish length with my driver (240 carry) but am one or more clubs shorter than average through the rest of the bag, even accounting for modern GI "distance" irons. But I strike it pretty consistently.
From the back tees I would be hitting driver or have to absolutely nut a 3W just to reach two of the par 3s, would have little chance of reaching three of the par 4s with a perfect drive and 3W, and would have trouble carrying a hazard off the tee on the longest par 5. I rarely play from those tees, but embrace the challenge of it when I do because pars feel like birdies.
From the men's tees I hit 4i or 5W into those long par 3s and par 4s, but still have no chance of reaching any of the par 5s in two shots. I hit driver on every par 4 and par 5 though, as taking any less, even on the shorter holes, puts me at a disadvantage. From these tees I am usually just trying to aim for the center of the green on the majority of holes, and the par 5s and shortest par 4s are my only real opportunities to have reasonable birdie expectations with a short iron or wedge in (assuming I hit perfect drives to get there). These tees are where all of the club competitions play from, and my dad, a former plus handicap whose game is trending to shit as he approaches 70, still always plays from here because that is where his regular games play from. He will be eligible to move up next year when he reaches 70. When I play with him, we go from the men's tees, even though I beg him to move up.
Otherwise, I have really enjoyed going from the senior tees, even though I am still a few decades away from being a senior. GHIN puts my course handicap from these tees at 73, so there is always the challenge/reward of knowing I should be playing it close to even par. I still take driver on almost every hole, and there are no short par 4s that I can reach. But on most par 3s and par 4s I am hitting 8i or less and trying to make course management decisions about where I want to be putting from, whether I want to fire at the pin or play it safe, etc., and on par 5s, two perfect shots gives me an opportunity to two putt or get up and down for birdie.
Having never shot under par on 18 holes, I recently decided that I should go Earl Woods on myself and play up until I break par. Fortunately, it took only one round from the forward tees (5250 yards). Even though I putted like shit, I birdied 16 to get to one under and missed short birdie putts to push it into the 60s on 17 and 18. That would've been cool, but I will take the 70. I have a couple even par rounds already from the senior tees, but if I get some putts to drop one day I will break that barrier soon as well. When I do I can justify moving back to the men's tees as the next challenge, but I think I will still prefer paying up, unless I am magically able to add 20+ yards of driver distance in my 40s.