Yes, the scene at the end of Act 2 is what hooked me on the series. It’s a shame they didn’t do something similar at the end of Act 1, because so many people stopped playing due to the slow start.
My most profound moment in those games was at the end of The Awesome Adventures of Captain Spirit. Even though it’s the smallest story in the games, that final dialogue put me through the floor.