I decided to go with the spotlight, but I seem to get the same problem with other types of light. In the viewport display using cycles renderer the spotlight shows up clearly. However when I use F12 to render the scene through the camera (again via cycles) no spotlight effect is visible. See pictures below:
Problem solved, the answer came to me this morning. As some of you probably realised I had at some time turned off the render visibility for the bulb (the little camera icon next to the bulb object in the collection panel). Turned it on and the spotlight rendered fine, simple when you realise, just wish I hadn’t spent so much time looking for a complicated solution.