The overhead of applying an avi as a texture is considerable. I've never done it in a game, only for special demos like this digital art project:
http://dm.risd.edu/~jhocking/screenCity/screenCity.html
http://dm.risd.edu/~jhocking/screenCity/screenCity.html