another one I thought of, from DS9 as well, was Take Me Out to The Holosuit...a lot of NINERs don't seem to like this great baseball episode, which teached Sisko a lesson about leadership. Not me, I love this episode...
A lot of complaints seem to stem from the time of the episode, but I loved it. One last full of fun ep for the series, though a friend who plays baseball seems to hate it with a passion.
I thought about Family but wasn't sure it would fit. It was nice to take the sci fi out completely and just deal with the human (and Klingon subplot) side of things.
Data's day sticks out in my memory as one of those episodes from one characters perspective.