The unintentional funny moments...let's see...Riker walking out of a room with his back towards the camera...Riker having problems with his thinking process/memory in the episode Genesis
...Deanna Troi's maybe you should consider serving aboard a transport ship...Picard's temporal psychosis...Picard's finger nails growing at an accelerated rate...Picard with hair...and Data cutting the cake with Troi's head attached....
The intentional moments for me is Data saying to Jenna in the episode In Theory
May I get you a drink dear? Excellent choice. I'll join you. Computer, two Calaman sherries. Would you care for some dinner as well? Darling, you remain as aesthetically pleasing as the first day we met. I believe I am the most fortunate sentient in this sector of the galaxy. Now, you relax. Put your feet up and I will take care of everything. Am I not behaving as a solicitous mate? You don't tell me how to behave. You're not my mother. You are not my mother. That is the appropriate response for your statement that I am behaving foolishly..etc. Then there is the episode where Data and Picard are aboard a Klingon ship and Data just stands there while Picard tries to get some sleep. Finally, there's the one good thing that came out of Insurrection... Smooth as an android's bottom, eh, Data?