IMO, Boxee is the closest thing in video to Squeezebox. At least in terms of the "magic" aspects. You don't require any server software and you don't need to pre-tag any video files. Everything is pretty much automatic once you point it to your videos (which can reside anywhere and in as many places as you'd like).