I have no metrics or analytics to say about how effective they are, but my take is most games shouldn't do it (especially for an announce trailer) and that they're best as a victory lap for games that are already successful.

Here's a nice talk by @perky.bsky.social on the process of making 2D animated trailers!