I love The Visitor, one of DS9' best hours. It was very emotional and I did have a bit of a cry when I first saw it. I also lost it during the finale, with Jake and Kira left alone at the end. I was already pretty beat up by it all ending, but the callback to The Visitor was nicely done.
The Jake/Sisko relationship is so special - one of my favourites in all of Trekkie-dom. I felt so bad for Jake for the loss that he felt here, particularly with both Cirroc Lofton and Tony Todd knocking it out of the park repeatedly. Brilliant episode all round.