I've been at church bazaar for the past 8 hours, so sorry I could not get back to you sooner.
It is expoxy, so it does have a smell to it, but not very much. I am sure it is a low VOC. By comparison, I do use the System Three 5 min expoxy and that has a pretty strong odor to it. But then again, it is 5min and not a 6-7h harden that a self levelling would be.
Yes it does cure water clear. The colder you use it, the slower it hardens. I have used it in my shop in the winter time and that is only 14-16c. I mainly use it in the summer time though.
I have used it over water based stain without any issues.
They do have quite a few different ones that offer. But i see you have gone with the system three. I might have looked at Aristocrat High Gloss Coating as they have some with a UV additive. I haven't used that though so I can't say how good it would be.