My friend bought an Accord V6 through that program.
Based on what I remember, he paid a very competitive price for it and there was zero haggling. I guess Costco sends your info and the dealer has to contact you and offer a standard rate...probably a bit above invoice.