The GTX 750 is not going to give you that good of a performance. The GTX 750 Ti however, is good enough for playable frame rates at medium and sometimes high settings for most contemporary titles. But again, if you have the money, the R9 270 or R9 270X (slightly more expensive than the former) is much better. Those AMD cards can be considered the mid-range GPUs in today's landscape. The GTX 750 series are in upper entry level.
One unique advantage that the GTX 750/750 Ti have going for it though is its extremely efficient power consumption. If I'm correct, it's the first card to introduce Nvidia's Maxwell architecture to the desktop market. This allows it to only use an estimated 60W at full load, making it the desktop card with the best power-to-performance ratio ever. Similar cards like the R7 265 use 100W to get the same job done. Therefore, it can be a wise choice if you have a low wattage PSU (~300-400W, possibly from a stock consumer Dell, HP, etc) and can't spend the extra money to buy a better PSU to support the also more-expensive R9 270/270X which use about 150-180W (which require a 550W+ PSU).
Basically, keep in mind that when you pay more money for the better card, you might also have to pay more for a better PSU.