I've been using it daily for years. Mostly asking questions in a separate chat window/app and then working its response into my code. And then I sped up the feedback loop when I migrated to Cursor where I began pushing the envelop and asking it to do more.
I think what wears off is that we're less impressed and then we start demanding more and more from it and getting frustrating when it can't do it. But that's different than a honeymoon phase wearing off. It's like how we're not really impressed by image gen anymore, we expect it.
But as an example of a selfish sense of loss I've experienced, I used to pride myself in being the only developer on any team who ever learned CSS. I could architect a good grid/flex layout with a lot of thought. I could do little things like make text in a small UI component truncate into {3 letters} + ellipses when its parent was too small. And most of all I could polish UIs to a point where I'd say they were perfect, even a form.
Now, LLMs are really good at doing the mechanical parts of the things I spent so much time learning. Like I originally said, I'm not shedding tears over here saying it's so unfair. But there is a sense of loss. And when I figured most people reading my comment would misinterpret this, I removed my comment. Because you can't make descriptive claims about how you feel online, it can only be interpreted as a normative value judgement about the world. Because I guess that's what it is 99.9% of the time someone expresses a feeling they feel, but not in this case.
Finally, the right way to see it is that now I can polish the UI to perfection, but I don't need to be a CSS expert anymore. Nobody needs to be. You can get an idea of how you want the UI to work and ask the LLM "make this one bit of text be the one that truncates if the window is too narrow" and it does it. And that's fkin magic.