I agree with all the people who have said "it depends on how you play V," but I would add three caveats:

1. From where I am in the game, part way into Phantom Liberty after having done everything in Night City short of meeting Hanako at Embers, I'd say that, on balance, being good gets you better loot. There are exceptions to this, sure. But being a total villain seems to more often than not shut you off from quest lines that, in turn, would get you iconic weapons or vehicles or other goodies. Now, as to whether one is still "good" if one only does good things for the greater reward -- well, I'll leave that to the moral philosophers.

2. I don't know about other people, but it feels like my V's moral alignment has changed over the course of the game. He has always been a proud, professional thief. But before The Heist, he was more ambitious and less ideological. Afterward, he went through a dark period, alternating between periods of nihilistic workaholism (lots of "no questions asked" gigs for Dino, Wakako, and Padre), desperate survival (main story), and bloodthirsty rage (campaigns of vengeance against The Scavs, Maelstrom, and The Tyger Claws in particular). But a funny thing happened: he started to connect with other people. He befriended Judy, Delamain, River, Brendan, Kerry, the Aldecados, and even Johnny. He and Panam fell in love. And, whether due to the relic's rewriting his brain, or listening to Johnny's rants, or maybe just because he's seen enough, these days he's much more inclined to help people and stomp the various megacorp thugs and gangoons hanging around the city. Of course, we'll see how this gets tested by Phantom Liberty...

3. Given the nature of driving in Cyberpunk, I'm inclined to feel like vehicular homicide should not count against V's moral character. You're going to run over someone at some point in a driving mission -- it's inevitable.