Counter Strike 1.6 Sex Movie Map !exclusive! [ UPDATED ]
The engine did not support actual video files (like MP4 or AVI). Instead, map makers had to create "func_wall" toggles or texture sequences. These sequences swapped standard BMP images rapidly to simulate a low-frame-rate animation.
If you want to explore more about the history of custom modding, I can provide information on: The from Hammer to Source 2 Counter Strike 1.6 Sex Movie Map
The most famous example is (a fan-edit of the classic map). It removes the hostages, adds ambient jazz music, unlocks the previously sealed upstairs bedrooms, and populates the courtyard with park benches and falling leaves. The terrorists and counter-terrorists aren't fighting; they are just people existing in a space. The engine did not support actual video files