For example paying for unemployment benefits and end-of-life healthcare just gets consumed. Similarly increasing military spending and having people just live on bases likely has a very negative ROI (as it removes people from the labor market).
The argument is that the government is in a unique position to fund infrastructure projects and do long-term investment in underfunded sectors. (Very high expected ROI, because - by definition - these are areas where some money goes a long way, that's what underfunded means, right? But simply maintaining a very large welfare state while economic productivity is bad is ... you won't believe it, but it's bad and unsustainable.)