Personally no longer on any kind of honeymoon, I think it lasted from around 2014 to 2015, so perhaps a year. It was new and exciting in so many ways, the EV thing. I believe Tesla changed the world with the drivetrain and that will always be their great achievement for me.
But by the time I exchanged my Model S to a Model X in early 2017 (after 2.5 years), it was more like if I don't buy the X now, I might wait for a long, long time to buy another Tesla... I was kind of fed up with Tesla, drained by all the stuff that is going on with Tesla overall, Model X delays etc.
It was getting long in the tooth. Still, I am glad I did buy the Model X. I know I wanted to experience the crazy doors and I am a believer in the BEV future in general. It is a good car, as is the current Model S. But for me, now it is pretty much everyday.
Don't get me wrong, nothing wrong with being everyday. It is everyday in a good way (certain specific bad things excempted).
But no way is there any kind of honeymoon anymore. The only time there are blips of that when other people gush about the car (and there certainly are Tesla moments still), but even then it is more gringe-worthy for me personally, it just reminds how special the car is seen as.
As for waiting, I am personally glad I didn't beyond for AP2. I bought the Model X at a good time, features-wise (much has been discontinued since that mattered to me) - and as said, if I hadn't, I might have delayed and moved away from Tesla. IMO that would have been unfortunate, I think the car I did buy was a worthy purchase overall (warts and all).
But it seems even the great EV drivetrain can get boring.
I've been enjoying some ICE time lately more than Model X. It is more a utility vehicle now for me.
If I was buying a Tesla now, I would definitely wait 6-12 months at the minimum for the next one, though. Perhaps indefinitely. Things have changed.