It's a nice name, but whenever I hear it, I think of how the French version was used in the 19th century as a slang term for a pimp, which really doesn't help me to appreciate it.
My middle name is Alfonso and I have always hated it. It was my great-grandfather's name, so that is nice, and am proud that it reflects my Spanish heritage, but I don't think Alfonso is a nice name at all.