I have (most of) Front Row working on 10.7 (i.e., movies and TV shows, but not music). I can post instructions if you are interested.
Briefly, you can salvage the parts from 10.6, and make symbolic links into your iTunes TV shows and Movies in your home Movies folder, and access it that way.