Go with manual can openers - I'm oldschool and like the added security of being able to open cans in an extended power failure! Plus its just for home cooking, it's not like you are opening dozens of cans a day or anything!
I have lived in Las Vegas now for five years and have been through three can openers. So, how come the can opener in my parent's house when we were kids lasted decades. I think it works to this day!
I always go with manual can openers. My thinking is: If ya too lazy to open a can, then you don't deserve to eat. Though the ones that kind of zip around the can on their own are pretty neat.