I've lived in Leeds nearly all my life, so I can speak for the roads etc but not the scene, as I don't really do much scene-ing!
The actual road surfaces are genuinely terrible. I will get that out of the way, potholes are something you will just have to get used to and be eagle eyed as half the roads are sketchy.
The upside of Leeds cycling (for me at least) is that you are never more than a mile or two from some decent countryside. Going out sort of North West you have Otley, Skipton, Ilkley etc, all lovely and if you keep going that direction it just gets better. Or if you go East you can aim for York or North York Moors, again breathtaking stuff and not actually pretty flat for a good amount of distance if you aim that direction. The same cant be said for the West, as you bump into something called the Penines, which is quite steep, but that is a positive IMO!
All in all, a few hills involved in Leeds cycling but excellent rides always nearby.