Have you checked out Xingyi?
I suggest that you need to look for two things above all else - a skillful instructor you gel with, and a style that suits your headspace. Perhaps that's one of those answers you don't want, but it's really the best anyone can give you.
But to answer more in the spirit of "which style", I studied wing chun for several years, and I found it great for self defence - primarilly because we did hard contact chi-sau every class! However I think the effectiveness of the wing chun I learned was very much related to the teaching ability of the instructor and the malice of the other students... there were other clubs around that produced some pretty average fighters (perhaps you could call it "family-friendly wing chun"). In the end I dropped out for two main reasons - firstly, I didn't like the mean, hardcore attitude that I thought drove the students to become such good fighters, and secondly because I met a bagua student who tore me to shreds in an instant.
Wing chun *is* better than a lot of non-Chinese styles: it's not too difficult to learn, and you get good results quickly... but it isn't the pinnacle if you're faced with a great fighter.
If I were back at the beginning of my training, I reckon I'd go with xingyi (hsing-i). In some ways it is like wing chun (simple, direct and powerful), but I think it's actually very much deeper and can lead you on to other internal arts.
The best offensive kungfu
The best offensive kungfu is "The Pungent Fist".
This kungfu concentrates on knocking out the enemy through deadly odours.
There's the stinky "Breath of Death",
The venomous "Fatal Flatulence"
and the vicious "Clothes Rotting Corpse Emmanation".
...
None of these are to be taken lightly.
Practicioners undertake a phantasmgorical dietary program, and exert control on their internal organs. Also they practice a kind of Zen which designates them as contraries in which they do every life function backwards eg. wash with dirt.
Practice of this is not for the uncommitted.
"A wish to go to Heaven is the very beginning of falling into Hell."