I use an electric opener with a knife sharpener. Less than $10. at Walmart. Had it for over 10 years. The blade comes off to clean it. Don't think you need to spend a lot on it but that's just me. Kitchen Works.
I have a 40 year old manual opener that's still going strong. I checked the brand and it's Swing A Way. Don't know if they're still made. Or if so, how well made the modern ones might be. But the old one's very sturdy and quite easy to turn.
A couple years ago I gave my Mom one of those sideways openers, which cut horizontally into the side of the can rather than cutting down into the edge of the lid. The ads made much of the fact that it wouldn't leave you with sharp-edged cutouts to throw away, but neglected to mention that the rim of the opened can was left razor sharp. I figured it might be easier for her to turn the crank on this one but it ended up being just as difficult as the regular type. And the thing broke after only a few uses anyway. Not a product I'd recommend to anyone.