I thought the Spider-Man games were excellent. Too short, but excellent.
Anyway, I don't know if this really signals the demise of Activision, going by its stock price (even if it is inflated) and the popularity of some of its games (particularly Tony Hawk) the company appears to be in better shape than, say, Acclaim or Interplay - if Interplay is still around, I may be making that up.