A more flexible animated (and possibly non anmimated) texture control feature could certainly make a big difference to FPSC made game levels and as with some others would be of direct added value to the product I would think.
This and variations have been well requested and debated - I guess we have to wait and see what develops if anything along these lines.
Perhaps the best we can hope for in the short term is an improvement to the current decal system.
Sophisticated animation effects equaling video type movies are not really possible with any current feature (apart from the story zone where appropriate) - but very limited results to meet with various objectives I would agree can currently be achieved. A little more flexibility to the number of frames and the control of animation speed for decals in themselves would certainly make a big difference for use in many situations.
More could certainly be seen as being needed than that but its probably too much to expect in the near future at least.
Who knows what the future may hold - certainly not I.
"I am and forever will be your friend"