Using Altivec amounts to the same as using SSE (MMX wasn't useful and AFAIK not really used) -- you have to write apps to use it. So most of the things that use it have relatively simple code which allows for parallelization. Media encoding would be the perfect example, another one are specific filters.