[rant]
This counts as yesterday, but I replaced the power window motor and lock actuator on the drivers side front door on my wife's Honda. We had had it in the dealership (not in warranty) for power steering noise ($200), and the window and door lock problems ($800). Fixed all of it for $120 in parts. The lock actuator wasn't easy, but got it done. Window motor was pretty easy, had it done in an hour.
The power steering problem was covered by a service bulletin, which the service guy didn't mention. A $0.75 o-ring, 10 minute job, done.
The car was a Honda certified car. My wife had complained about the window making noise at least 3 times while it was in warranty, starting about a month after we bought it. About 2 months ago, it made a huge noise when my wife rolled the window down, then quit working completely shortly after. They never did anything about it. When I mentioned this to the service guy this time, he said that Honda doesn't consider a part bad until it has actually quit working. He did get a 20% discount approved. Fuck them. All fixed now. I may contact the district zone office anyway to see if they will do anything.
[/rant]