The sweet spot for price/performance is typically at the $250-300 price point, the further up or down you go from there the worse value you get.
However, if your after the best performance possible then a 780 is a good value. It performs basically the same as a Titan, but for $350 less.
Ultimately, buy the best card you can afford.