I hate modern packaging.
Even cans that have pull tab tops- the tab just comes off and leaves an unopened can, often with the seal broken so that it makes a mess when I have to open it with something else.
'Child - Proof' is nothing of the sort- human proof is more like it.
Of course, that is not true for 'child-proof' lighters, that a three year old with one hand and two broken fingers could light.
I gave up long ago on those can openers that cut the top off like you mention, because they do not last.
I have never found one that was well built or repairable.
The electric ones are ok if you can afford them, but they always seem to make as big a mess as if I had opened the can with the claw end of a hammer- at least when I use them.
The only one that lasts a few years is the old fashioned type that has a bottle opener on one end, a juice can opener on the other, and a butterfly handle that turns a gear wheel so that the can spins under the blade.
Even when dull, you can still open a can with enough effort.
But the very best, most long lasting can opener?
The P-38 Military issue.
Never fails.
Lasts basically forever (til you loose it or it gets stolen), and it can be sharpened.
If you want to open cans, by far the best for at home is an 'industrial type'.
This is what restaurants use to open ten 5 lbs cans of tomatoes in 5 minutes.
the 'butterfly' (my name for it)
the P-38 (great for camping!)
the industrial