Google Video shows a new link next to search results: "Start playing at search term", that sends you to the first occurrence of your query in the video. This works only for videos that have closed captions and it's useful if a video is long. Soon you'll be able to search inside a video.
For the moment, there aren't too many captioned videos, but you can try the new feature for Google TechTalks videos.
