Started watching Nitro on the network which got my mind thinking about Roddy Piper………

When he showed up in WCW at Halloween Havoc 96 – was this a "big deal"???

Did Piper still have enough value to justify a big match with Hogan and the push that came along with it???

Yes.  Vince was dumb enough to never run it on PPV, so WCW did and made the money off it.  Now, whether he was worth it AFTER the one big Starrcade buyrate is another argument entirely.  But they made their initial investment back with no problem.