Mass Effect's conclusion was so, so awesome. The bits leading up to that could have used a little more variety, but it was a great game nonetheless.
On the other hand, Bioshock starts out AWESOME and slowly turns into a pile of shit during the unnessecary "boss" at the end and the awful 10 second pre-rendered Binary endings.
Both great games with different, but equally major problems.