It was better than AC3, but I felt Revelations is where the "real life" overarching subplot of the series jumped the shark, personally.I don't get why Revelations wasn't more popular, I thought it was pretty good, especially when you consider that AC3 was the game that followed it a year later.
Edit: Actually Brotherhood seems to be where it started getting weird. I think what turned me off of Revelations is that they didn't do much with the present-day story until like the very end of the game. It just felt derivative of Brotherhood.