Does coffee still affect sleep even after drinking it for a long time?

I think that’s all about you and the dose.
Basically, you should know that coffee doesn’t wake up. It only prevents you from falling asleep.
This is a finer but great difference. You can always sit in bed in the evening, but you may not be able to fall asleep because it prevents coffee. Depending on how much and often you drink coffee, your body learns how to reduce it faster or pour out more sleep hormones. On the other hand, only one coffee helps to get undressed or to drink more coffee. (The awake feeling of what happens in the morning when drinking coffee is, by the way, in most cases a short kick that comes through the bitters.) 🙂
In short: It comes to the crowd, but basically yes.