And there's nothing wrong with that. I enjoy a good wank every once in a while myself. (Talking FANwank of course

) It just happens to be very distracting if it acts as a substitute for a good story on screen. ENT Season 4, I'm looking at you... As for the movies, I hated Robert Picardo's cameo in First Contact. No unnecesary, added nothing to the story except a forced and unnatural comic relief moment were none was called for.
Also, all these so-called fan valentines have a way of excluding uninitiated viewers from the experience. And I think even the most die-hard fans these days would agree that new fans need to come onboard if the franchise is to survive.