The Sigma 70 is a real 1:1 macro. The DA35 and the DFA 100 are also 1:1 macros. They will all let you take photographs of the same magnification. There are two big differences focal length makes in macro. One, it affects how far you are from the subject at 1:1. You will be very close in any case. With the DA 35, at 1:1 your camera's sensor (not the end of the lens) will be 14cm from the subject, the Sigma 70 will be about 26cm, and the DFA 100 will be 30cm. Not a huge difference, but it can make a big difference for insects and such, and also has a big effect on lighting.
The second effect is the same as any other shot, the background will be compressed or stretched depending on focal length.
Here are some macro shots with my Sigma. None of these are cropped. The Bee isn't at 26cm, more like 40 or 50cm. The flower and cactus needles are pretty close to 26cm. Click on the photos for full sized images on Flickr.