I'm excited to add this feature. It's a hard one technically, so it'll be a bit before I do. But I'm definitely planning on it.
What formats would you like supported? I've had requests for GIFs and APNGs.
I second this. I would go for APNG instead GIF or WEBP/M :
But not sure that Unity handle this format natively. Instead it could be easier to just import a bunch of frames for each image, as a sequence animation.