Have to say I have mixed feelings on those 2-hours. I really didn't like the way Dean handled Lisa and Ben, and although I liked seeing Rafael blown to bits, I'm not sure about Crowley's escape and Cas becoming the new God. It was also a bit strange to see nearly the entire final hour take place in Sam's head.
On a positive note, Cas having "plans for Crowley" sounds ominous, and Crowley being alive means more Mark Sheppard, which is never a bad thing. But all-in-all, that finale left me feeling largely unfulfilled, like it's part 2 of a 3 parter, instead of a season finale.
Season 7 should be interesting though. Some changed dynamics and a lot of issues left to deal with, from Sam remembering the pit to Dean beating himself up endlessly over Lisa and Ben (and Cas), to seeing how the brothers deal with Cas (and Crowley).
I guess, though, I expected to be blown away a little bit more.