I think the whole religious type ending of DS9 was always gonna be difficult.
I have no time for religion in programmes in general but do think the writers took a brave chance and it worked in general.
As for the number of times i watched it, my routine was always 3 or 4 episodes in a row a few times a week and run through the series, give it a break then for a couple of years and then repeat.
Only finished it about a month ago so now starting on voyager,only ever seen it once in a complete order a good few years back
TNG I have seen every episode a few times but not in its full order.
Enyerprise and TOS I have seen just the once