Usher is the ultimate movie and video assistant because it can see and manage pretty much everything:

Usher can manage the videos you keep on your hard drive, and it will do so even if you don't want to move your videos and movies into Usher's library—it's your choice as to whether or not Usher moves things into its library, or just helps you manage your collection in place.

Usher can see videos stored in iTunes, iPhoto, and Aperture, providing easy management for these collections. You can add details to these videos, and then use Smart Playlists (as in iTunes) to quickly filter your collection on those details.