I would agree that it didn't hit the marks set by Obama, but disagree that this makes is a "failure." If it kept the market from dropping to 5K - again, we can never really know - then it succeeded, by a lot.
The stimulus was by design an extremely imperfect measure. It passed at a time where time was of the essence; that phrase doesn't even really go far enough. They needed to get something done, and fast, just to reassure the markets, if nothing else. Had they gone for a bill which allocated the money perfectly and didn't have waste, it would have defeated the purpose at that time.
That's why people talk about a 2nd measure. Okay, we stopped the crash; now, let's take our time, put another measure together of equal value, that is more targeted & effective. It's not really just "dems"; there are those in the economic community who thought that the stimulus should have been about twice as much, anyway.
If the stimulus did help the market turn around & start growing again, and I don't doubt that it did, it was cheap. We're talking about trillions of dollars gained (or lost) depending on those swings in the market...