Fisheye front attachments are rarely useful, as image quality suffers greatly. Nikea's example convincingly demonstrates this. However, a front fisheye in combination with a relay lens can be advantageous if the lens itself won't fit physically, or its image circle either is too small or too large for the camera format at hand.
This is the 10 OP Fisheye using a relay lens on my D2X to shrink the projected image circle. For my current fleet of FX cameras, the 10 OP can be attached directly so no relay is required.