Is there a noticeable difference in performance between Intel Core 2 Quad Q8200 and Q9400?

There's not much of a difference really. Both processors are very powerful and more than enough for just about anything. Either one will make you very happy. Trust me! If money isn't a problem, get the better one.