Cinematography.com has an excellent comparison of Super 8 Ektachromm D100, along with comparisons with older Ektachrome and Fuji. Film looks great.
Cheaper Super 8 cameras were only able to work with 160 tungsten which was converted to 40 asa daylight using a filter (the “sun” symbol). Converting daylight film to tungsten is not practical. As noted by Agulliver, the better cameras read notches in cassette. How many notches varied from camera to camera. I have a list of what cameras read what notches, but too lazy to look for it. Recently shot a roll of D100 in my Nizo Professional and ready to send for processing. My Zeiss Movieflex (the RollesRoyce of Super8 cameras) can handle any conceivable notches; asa is dialed in manually on my Beaulieu, so notches don’t matter.
What I am really waiting for is Ektachrome D100 in 16 mm. If Ektachrome:BW cost ratio is as close as price of BW 16mm, the difference in cost between Super8 and 16mm Ek D100 would not be that great. What is lost with 16mm is compactness of S8 cameras.