Many retired millionaires end up spending a surprisingly modest amount.