On the Fallout 3 Details page it says that the CD/DVD release works and that the Steam version (GOTY edition) is known not to work. Perhaps this is backwards?
What's odd for me is that other people seem to have gotten the DVD to work in WINE without seeing a SecuROM "No CD/DVD-ROM drive found." error. Why isn't it working in Crossover?