I definitely wouldn't use regular canned fruit; it's usually packed in heavy syrup and has a cooked character to me. The Vintner's Choice ones are supposed to be the homebrew brand for Oregon Fruit's Aseptic Purees,
http://www.oregonfruit.com/fruit-brewing/category/aseptic-advantage/advantages-of-aseptic-purees
I used canned raspberry puree a long time ago when it was still sold under the Oregon Fruit brand, one can in a five gallon American wheat. The flavor was way too subtle in my opinion, but I like most of my fruit beers to be fairly fruit-forward. If I were to do that one again, I'd use two cans minimum. I've had good experience with frozen fruit from the grocery store, but sometimes it's not from local growers, if that concerns you (I think the last ones I got were from Croatia). You also have to sanitize it yourself, but it usually is quite a bit cheaper...but still not cheap. You can also try using flavoring to supplement natural fruit, but I'd recommend doing it sparingly.