A CFL cannot be simply installed in an incandescent fixture and then expected to produce a visual appearance that is more than washed out, foggy, and dim.
If the CFL should be used for lighting a particular space, or an object within that space, the fixture must be designed to work with that lamp, and the fixture with the room.