Lohse's quest is in my opinion THE best companion quest, what a roller coaster ride that was, and an excellent finisher.
Come close to second is Fane, because his story is literally the game's story.
Havent tried on others, but Sebille's rebellion against god tree was pretty anticlimatic. Also Sahila end up as a parody than mattering for anything.
