Banjo Kazooie and Devil May Cry 3 come to mind. God Hand is up there if you pretend the second to last boss is the final. I think Bayonetta was a lot like God Hand in that regard. Star Ocean 2 was pretty solid. FF8 for atmosphere. Ace Combat 5 has a great final stage/boss.
--
GameFAQs isn't going to be merged in with GameSpot or any other site. We're not going to strip out the soul of the site. -CJayC