Upper mid card behind Austin, Taker, Rock, Mankind, Kane, Angle, and HHH. If he sticks around longer maybe he gets a run with the belt when those guys left/worked less and it started changing hands more often.
Then again he was older than all those guys and Michaels guys so he probably already peaked. I will say his loose cannon gimmick was pretty interesting at the time in both WCW, ECW, and WWF so he definitely had value.