Yeah, for all Generation's faults, of which there are many, Soran wasn't one of them, and he's one of the reasons why I still kinda like the movie regardless of the fact it's objectively pretty bad.
Soran's a good idea for a villain, with some good lines and motivation and
Malcolm McDowell, but he still isn't that good. His reasoning is completely preposterous - he allies with the Duras sisters and helps them get trilithium, fights the Romulans, anatagonises the Enterprise, sets up a way to get into the Nexus by annihilating a planet when, you know,
he could fly into it. He's a little too small for his shoes of epic movie villain also, and I was sick of the 'dead wife' canard long before Nero came along. It worked for Khan, but that doesn't mean every Trek villain needs it and Khan had the added advantage of us actually knowing who his wife was (though, er, given the misogyny inherent in the character that might be a strike against... whatever, Soran still sucks...)
McDowell never manages to come off as menacing either, merely a petulant, irksome old man who's off on a daft scheme that a couple of other geriatrics need to thwart. If McDowell isn't creeping the hell out of your audience you're doing something rather wrong, really.