Hi Doug,
Managed to get it working in the end! One of the main problems I had was the ImageFX CD I bought from the SWAG 2020 meet in January earlier this year simply isn't detectable in my particular CD-ROM, so once I'd identified that the system could see the CD-ROM over the connection, the CD-ROM device was properly configured in the tool types and the cable was in the correct port I had a false-positive from having a non-detectable CD in the drive. All my "non-detecting" CD's work fine on my PC under emulation, but I recall old CD-ROMs could be picky back in the day.
More haste less speed was the lesson here - a careful series of tests making only one change at time revealed the problem. Really I should know better, most of what I do is in an IT support role in my day job. Just having had my 1200 board back from recapping I was excited to get everything running as quickly as possible so changing 3/4 things every test I was bound to miss something

.
For anyone else digging up their old Blizzard / SCSI unit and external CD-ROM the steps I took:
a) Copy CD0 from Storage:Devs to SYS:Devs
b) Be sure to configure the 1230scsi.device and the correct unit number in the tool types of CD0 to match your setup.
c) Open CD0 with a text editor (Multiview will do) and check that the CD file system is set. I'm using 3.1.4 ROMs and Workbench 3.1.4 so the CD file system was already in L: and already configured in CD0, so didn't need to change anything.
c) Check if you need to plugin / activate / set a terminator on your CD-ROM. This will depend on the CD-ROM you have and should be covered in it's documentation (if you still have it after all these years!)
d) Ensure if like me you have 2 connectors on your CD-ROM that you don't use the one the termination is set on

Right cable in the wrong connector was a particular issue here.
Loving your videos by the way!
Thank you very one for your assistance.
Gryfon