Chapter cliffhangers are fun! I want to be engaged and wonder what will happen next. If the story itself ends on a cliffhanger... I guess that kinda depends. Is it setting up for a sequel? Is the author leaning into ambiguity? Both can work if the author can pull it off. I don't think I would drop a fic for cliffhangers; I usually drop fics when I stop caring about the story/characters, or reading the story feels more like a chore than something fun that I look forward to.
I think it's fine if a cliffhanger asks new questions, but if there are any unknowns or uncertainties during the story I'd rather have them answered by the end though.
It depends on how many months should I wait for the cliffahanger to be resolved? Ahahaha if the author goes on hiatus after a cliffhanger, I feel extremely stressed!