It wasn;t shits other than Austin, Rock, etc.
Firstly, like MS said, there were many more feuds than there currently are, and the ones that were the lower card feuds, kept you entertained and into the characters. Nowadays, noone gives a fuck about the lower card guys, whereas then, they would be pushed appropriately.
Secondly, it was fresh. It was rare to see people mooning you, or wearing a thong, or giving you the finger, or slapping their boss on tv before that, and the attitude era came along, and introduced it to us.
Thirdly, and this kind of plays off the previous point, but you say stuff like the things that happened back then weren't new and exciting. Well, part of why we loved the attitude era WHILE it was here, was that there was endless new ideas. Hell In A Cell, Iron Man, Inferno match, ladder matches and tlc matches were all either created or brought to the spotlight during this time.
Thus, we love the 'tude era