Just my experiences of these locations.
I did really well working in Cheltenham and will defo go back.
I find Sheffield and Leeds are good during the day. (Leeds can also be busy in the evening)
Manchester seems like more of an evening & nighttime place to work (I’ve never had much interest during the day - but maybe that’s just me).
Nottingham was decent for me and I’ve been quite a few times - but I only seem to be busy if I advertise at least a week in advance.
DM me if you want info on workable hotels in these locations.