Assuming the presence of a sovereign wealth fund which does work somewhat logically for programs like social security - that would make sense. The government should sensibly invest money they're holding onto... however, it's unrealistic to ever expect the government to tolerate a level of risk and thus a rate of return above what you're personally comfortable with so it's unrealistic to assume that the government will be as efficient with money as you'd personally be if they'd never taken that money.
Additionally, a lot of these programs will pay out beyond what you've personally put in - programs like Medicaid are nearly entirely social subsidies to ease poverty and financial distress, so I'm not certain where you'd find the money to pay for them if not looking at either other people's taxes or debt.
As a taxpayer I expect the money I give to the government to be evident in some social projects but I don't personally expect that for each dollar I pay that I'd see a dollar in benefit to me personally. I have a belief that I indirectly benefit from the expenditure of charitable safety net programs even if I never expect to collect from them directly - the improvement in the lives of those around me is to my personal benefit by making society more just and egalitarian as well as reducing the incentive for crime which is a difficult to measure but observable direct benefit to myself.
The fact that so much of our budget goes to debt servicing is probably my personal biggest objection as it is effectively just a wealth extraction from our earn national budget to some select individuals.
