Generic? There's nothing generic, really, about any 'Northern' accent, they're all different. You can tell, I'm sure, that I am a Northerner and I speak Lancashire.
I'm not really sure on what accents I find attractive, myself. It depends on the speaker.