It can't be stressed enough. A good can opener is worth its weight in gold. Don't scrimp. Don't get the cheapos. It's not worth it in the long run.
And no, not electric ones. You don't want to depend on something electric to open your cans. Think about it. And really, if you don't have enough energy to use a hand-held can opener, you should give it up.