When Batista first turned face back in 2005, he was as over as just about anyone has ever been in the history of the WWE. He was huge. That was a perfectly designed, perfectly executed face turn from beginning to end. One of the best turns ever.
He was never really able to maintain that or regain that overness. For me, I lost interest in him in 2007 when he kept losing title match after title match but kept getting chance after chance and actually won the title match. (I think it was seven times he challenged for the title and didn't win it, over a five month span, before he got the title back.) Even as a face, you just couldn't help but feel like this guy needed to stop getting title matches. The heel turn in 2009 helped give him new life, to be sure, but he left so soon that he didn't really have a chance to get a full heel run. And now he's back as a face.
He's got a great look(although, clearly, it's not what it was 9 years ago), sure, but he's not very good in the ring or on the mic. He doesn't really seem to have that spark that connects him to the crowd.
When he was gone, was anybody really saying "I want them to bring back Batista!" or "I can't wait until Batista comes back!" or anything like that? I didn't really see it. And I didn't really see anybody following his ventures outside of wrestling, his movies or his MMA matches. He seemed to be mostly forgotten while he was gone, aside from when he would do an interview saying he wasn't coming back or he was coming back.
I like Batista. I think he can be a productive member of the WWE roster. But I think a big part of his current roster spot is everybody still clinging to the magic from 2005. That moment on Raw when he was choosing which champion to face at Royal Rumble, gave Triple H the thumbs up before turning it into a thumbs down and putting him through the table. If that never happened, if Batista had remained as Deacon Bautista with D-Von Dudley, would he ever have become anything special? I'm not so sure.
Basically what I'm saying is I think the reaction he got upon his return is a reflection of what he is, a fringe main eventer, rather than what WWE wants him to be, a bonafide superstar. And since his return was pretty much exactly what I expected, I guess that means I wasn't let down.