At least on FreeBSD you can use mplayer with a vidix supported card to play almost every movie on the console. It's also fun to use this with an endless-loop video to have sort of a background image
The same goes for almost every program supporting SDL output (including mplayer as well) as you can compile SDL with libvgl support, set SDL_VIDEODRIVER=vgl and as a result see the graphical output directly on your console. Besides this mplayer supports aalib too, of course
