Nice. Tier 1 head-canon ending is RoTJ. Tier 2 is TLJ. Never thought of it that way too and it sort of recontextualizes how I thought about TLJ. I too don’t find it all that decent, as most of the first half is the more offending part. But the ending itself is the least offending, to me at least. Despite my misgivings, I still liked how Luke was treated, and he had his big moment toward that end.
Along that idea, how Luke wanted Rey to understand the flaws of the Jedi Order, there is indeed some ambiguous, yet hopeful, implication that Rey restores the Jedi Order with the parts that work and discard the rest that are trash. The lack of the cliffhanger is frustrating, since it doesn’t excite interest in the next sequel, but I never did consider that frustration to be synonymous with finality. This doesn’t excuse the very mishandled treatment of a trilogy, but it ironically does seem to act like the final movie.