Again, anecdotal. I have no idea if this is the general case.
Even at peak coffee, more coffee still stimulates my mind and makes me infinitely more focused. The only times coffee hasn't worked is when I'm genuinely sleep deprived, although I typically get 6-8 hours of sleep.
I have been on and off coffee several times and my anecdote is that if you have coffee almost every day, it does provide you an alertness boost, but:
Your average alertness over the course of a day with coffee (when you're adjusted to it) and over a day without coffee (when you're adjusted to that) are about the same. The one with coffee just has more ups and downs. Without coffee it's more even. IMHO that evenness is a good thing.
Was that your baseline level without coffee? That's hard to know.
So, I'd be inclined to believe my baseline levels are generally around where I am now (a cup of coffee every few days). Taking from that, I do have a lot of faith that coffee is still a great mental stimulant for me, and it's not just bringing me back to my old normal.
Of course, I know I can't provide anymore evidence of this other than personal experience. I don't happen to have an MRI machine in my closet.
This is why users of stimulants, like caffeine, have to increase dosages over time to maintain the same effects. It's also part of why you have withdrawal.