We need to be clear about the features of money we are talking about (and there are
many):
For money to work as a convenient way for people or companies to settle transactions, long-term inflation or deflation does not matter. If A wants cement and has mangoes, B wants pants and has mangoes and C wants mangoes and can do tooth fillings they just need something universally accepted to convert what they have into. And, a bit later, buy what they want. Most money satisfy this, but usually people want more features.
For money to also be a store of value it should maintain its purchasing power. This allows an individual to, say, pay for an education of a child when the child grows up: I can save in today's money and be fairly confident that when the time comes to pay it will cover the (future) cost. This feature is what people tend to refer to as "digital gold" as gold generally maintains its purchasing power over very long times.
For money to enable governments to stimulate society in different ways, money should be deflationary. Easy long term store of value makes people less responsive to short-term government stimuli. Without deflationary money a government cannot print extra money when it overspends or if not enough players want to lend to that government.
The last two tend to cause eternal strife between individualists (who want small government that does not do things people did not explicitly ask for) and progressivists (who want to push the society along the path they see as the best one).
There are more features of money (highly recommend reading "Broken Money" by Lyn Alden)