I know what you mean (first paragraph). I was too young to get into Hulkamania and always regretted that I couldn't have been there, when I started watching during the Attitude era. (It's funny to think I was ever too young for anything these days!)
I quit watching during the WCW invasion angle. They bungled it IMO and with no competition the writing got lazy, and there were too many new wrestlers; to their credit they realized this and shifted to having the separate Raw and Smackdown brands. But the product still sucked, and by the time it became WWE I was done with it.
I've tried to get back into it but that time has passed me by. Plus they have commercials in the middle of matches now.