I'm not sure how it is in the U.K, the Royal Family doesn't cost much for Canada (though many seem to think otherwise). I think they actually give to the country rather than take because a small amount of "Crown Land" is actually owned by the Royals and the proceeds from the land goes to the country rather than them (though they do receive a small amount of the proceeds).
Most of the Royal visits are actually spent on the local economy too- most of the 'expense' of the Queen's last visit was actually spent on medals and recognizing Canadians rather than the visit itself.
And the country gave a pair of Canada Goose Jackets to Prince William and Duchess Kate for their wedding. They're not that expensive. Seriously, I bought a brand new one a couple years back for myself.
I'm a 'monarchist' for the simple fact that while I'm not a 'tin foil hat conspirator' I'm not a fan of any of our political leaders at the moment (Conservative, Liberal or NDP). Hell, we can't even figure out what to do with the Senate which money we funnel into annually dwarfs the Royals significantly.
And if we were to lose the Royals, the Governor General would replace the Queen... so we'd have a General appointed by the Prime Minister who...appoints the Prime Minister at best. At worst, we end up getting an election every few years... which is an even larger waste of tax dollars.