I haven't tried all that many varieties of beans, but my favorite for taste so far has been Vermont cranberry beans. I use them as green beans, not shell beans. I have Kentucky Wonder pole beans this year and they are more productive than the Vermont but not quite as tasty, IMO.
I think that all-in-all, DH prefers store-bought canned beans. Can you imagine!?! That's what he was brought up with.