I understand why people didn't like it. I guess I'm one of the few who found the end satisfying. I did say to myself "is this it?" But that was only because I wanted to see the scenes last longer not because I was unsatisfied with the concept. I always thought the fact that we see Sisko afterward meant the door was open for future stories for both Sisko and Dukat (whether in movies, books or just our imagination), so in the end I was satisfied with the "fire pit" ending because I didn't see it as a death scene. I think I remember in an interview Rick Berman stated that he wished they had a few more episodes to stretch it all out a bit more because it seemed a bit rushed in places. But I can totally understand if it wasn't your thing.