I am actually a royalist, I think having a royal family in the way we do gives this country something that many other countries seem quite envious of. I like the history of it all, and the pageantry. I think the monarchy give a great deal of pleasure to a great many people. You only have to see the crowds that turned out for the royal wedding (I wasn't one of them). Equally however I would like it trimmed down a lot. I think we need the monarch + consort, the heir, and a spare, and a couple of back ups. Once the queen is no more, I think we should have Charles with or without Camila, William plus Kate and the new prince, plus Harry. Freeloaders like the loathsome Andrew and his jumped up brats need to get jobs and support themselves.
I do believe we should still keep some of the traditional trappings of royalty. There's nothing wrong with a bit of pageantry from time to time because it is so steeped in the history of this country, but it will have to come within the framework of a more hands-on monarchy. Also it should be paid for out of the royal purse - and goodness knows the Queen has more than enough money to bequeath to her heirs to keep it going for decades, and Prince Charles isn't short of a few £££ either.
I agree about the hangers-on as well. If other members of the royal family can't get a job, then they should either do voluntary work, like Princess Anne does, or go on the dole same as everyone else.