How to create light beam effect? (Alone in the Dark opening)
You could try with a cube encompassing your scene, and you plug a Volume Scatter node into its Volume Output to create a mist. I'm personally struggling with this solution so here is a solution with compositing that comes not too far.

It must be much easier with Eevee and the Principled Volume, but your question is for Cycles and I can't make Eevee work on my computer.

I guess it can be improved:


Create your title. Give it a black Diffuse node, put in front of your camera. Duplicate the title, put it behind the black version and on another layer, in Edit mode extrude a bit and scale it a bit with Shrink/Fatten, give it a white Emission node, with a Strength of 2.





In the Render panel > Film, enable Transparent so that you layers are transparent. In the Node Editor / Compositing, organize your nodes: Basically you need to mix (Alpha Over) the render layer with the black title with the render layer with the white title. I put some blur here and there, but the important things are to put a Sun Beams effect after the white title and a Glare effect just before the Output. The Sun Beam will create the beams behind, the Glare will fake a bit of glow in front of the black title. And you can move the Sun Beam X and Y value as if the spot was moving behind.




Here is what it gives: