Anor Londo is probably one of the best final areas, and Smough and Ornstein one of the best final bosses in all of videogames.