Yeah, the Sigma 35mm f/1.4 ART offers a lot of good stuff for the price compared to Canon or Nikon!!! And you are right, 100%; 24,28,35,50mm are EACH very,very different lenses on full-frame, with the 24 and 28 being wides, and the 35mm being that gloriously useful semi-wide-angle look. I used to own the very old, pre-Ai version 35/1.4 Nikkor, then had a newer one later for a short while. I've owned the 35/2 O.C. Nikkor, and the 35/2.8 pre-Ai Nikkor, and the 35/2 Ai-S...I really,really,really find that the 35mm prime length is versatile.
For me, 35mm on FX is good for indoor events, and you can use it for fashion/portrait type stuff as well. Sue Bryce LOVES her Canon 35mm f/1.4-L for single-person glamour portraiture...but of course, at closer ranges she mentions that she needs to warp the upper arm areas on many shots because it does tend to enlarge body parts when shot from her typically fairly close ranges. I looked at the 35/1.4 Sigma ART and gave it a long, hard look, and then trial-shot a few frames with the Nikon 35/1.4. Ehhhh...the Nikon has a LOT of color fringing at wide f/stops...a LOT more than I wanted to see on a $1700 lens. I do not like that longitudinal CA on the Nikon 35/1.4....reminds me of the Canon 85/1.2-L...very STRONG green-fringed outlines around objects that are out of focus in the foreground, then magenta fringed objects that are out of focus in the background...I do not like that look, not at all. I think the Sigma is probably the sharpest of ALL the 35mm lenses, if pure, utter sharpness is the criteria, then it is #3 overall according to DxO Mark, out of 72 or so lens models tested on the D800, the Sigma 35 ART tested out and ranked at #3 in terms of overall total sharpness, behind the 84 1.4 then 85mm 1.8 AF-S G Nikkor lenses, so there is no doubt the Sigma 35 ART is a bitingly sharp lens.