I'm certainly not a fan of it. It's not their fault I'm just one of an endless number of people they deal with so I don't think neither want nor believe their apology. However, since there job to resolve questions and concerns I want them to focus on that. I'd rather them say "Let me see what i can do for you." That still a boilerplate line but it tells me they are looking for a solution instead of just trying to coddle me, which I find highly insulting.
I especially hate when a CSR picks up after being on hold to go through some diatribe before I can speak. Make it simple, "My name is , what can I help you with?"
I go further—I can't stand being asked 'What can I help you with?' I don't need their help.