Looking for the font from the title card for the film Light Sleeper (1992)

[Member Dro…]

I'm guessing perhaps it's just a simple font and the designer outlined it?

[Member Ric…]

Looking at the details (the |R| especially), I would say it is a pretty competent manipulation of dear old Arial.

For wide sans serifs with small caps lowercase you can look for the various interpretations of Engravers Gothic, Blair, etc.

For 3D effects, you could start from this list: