Derby is a small Midlands town mate, not a continental city. The "red light scene" might constitute a few roads where street workers ply their trade to taxi drivers etc. I know nothing of that other than its Normanton / Peartree area.
Where are the best places in Cardiff - I'm up there sometimes (pre covid) and might give if try...