Ys: Origin and Etrian Odyssey 2 are both great games in which the entire plot is essentially "climb this enormous tower."