An inflation rate of between 1% and 3% is generally seen as a sign of a healthy economy (There is sufficient demand for products that some prices can naturally rise, without causing economic disruption. It also implies a low unemployment rate, in that the economy is sufficiently close to full employment to be able to tolerate some price movements)
Some central banks even go so far as to formally announce a inflation target, which gives the markets a more predictable way to forecast interest rates. See http://en.wikipedia.org/wiki/Inflation_targeting
OTOH, hyper-inflation implies a lack of confidence in the currency and economy.
In a lot of ways this is similar to unemployment. Generally, low unemployment is good for the economy (and presumably society) until it reaches a point where businesses are unable to grow because of a lack of labor. When economists talk about "full employment" they usually mean this point - where labor constrains the economy - rather than an actual 0% unemployment rate. (While this sounds quite harsh, there are good reasons why any economy will have an unemployment rate greater than 0%. For example, often the centers of population do not coincide with the places jobs are)
Therefore it isn't as simple as inflation bad, no inflation good. Rather it is too much inflation bad, any deflation bad, and you need to be in the middle. Which means that you want to maintain a small amount of persistent inflation - just enough to avoid the risk of miscalculating and going into deflation, but no more.
A big worry for the USA at the moment is that the current credit issues could lead to deflation.
ie. if demand for homes was normal and not stimulated by easy money then there would not have been a housing bubble. a dotcom bubble. etc.
Government stimulated demand is the problem not the solution. (see my other post a few msgs above)
What scientists, technocrats and economists forget is that public policy is rarely driven by rationality. It is driven mostly by private interests, demagoguery, blind ideology, prejudice and the public misconceptions.
The idea of taking a little bit of a very dangerous medicine is something that no one should take lightheartedly.