No, he was only a villain in his first appearance, and briefly after that, his comics history spans over 200 issues only maybe 30 of those has Venom as a bad guy, even with gargan and that one guy who was running around with a part of a symbiote.
Most memorable is debatable since almost nobody remembers Venom's character outside of the McFarlane covers.
Being a good guy, is a big part of his character, he kills badguys, he's not really evil. Only time he kills innocents was in his debut and he does not like doing it, can't remember him doing it after the one security officer. He was also a hero working for the government for a while, but before that he would help out at halfway homes, protect street kids, take care of the homeless. He's more of a hero than Frank Castle is.
He looks 10/10, I and a lot of others just wish he were the same size as Venom or around standard 12 inch size. It's honestly painful to see a perfect carnage figure like this and know how out of scale it is. I haven't seen the movie yet, I'm just a big fan of the character,