Here's the profile I use on all my computers.
The dotted line represents the minimum fan speed for this GTX 760 (43%). So this video card's fans never go below 43%, but if I change the video card I won't have to change the fan curve.
Most video cards run below 40C for normal tasks, so if you have a newer video card that can idle the fans, it'll be quiet and the fans will kick on when it warms up.
My GTX 960 video card fans will shut off under 40C making things quiet for everyday tasks.
If your video card still runs hot with this profile you can try moving the 100% point to a lower temp. For example, my R9-380X video card runs hot, so that profile is set to 100% at 75C. My R9-380X has a poor cooling solution even with 2 fans.
If your video card still runs hot after that, you may need to adjust case fan speeds to move more air past the video card.