Depends on him. If he says negative things in his first press con. then yeah it will be. If he shows respect to the club gets results. Good signings etc then no it won't be like GH part 2.
The return to Liverpool however, will be interesting
He will definitly need a good start to get the fans backing, also some exciting signings. His transfer record bothers me but he is a known name across European football which means he can attract a most exciting pool of players to Villa than a Hughes or Martinez. He just needs to make the correct choices.