Just tested with my 1080 FTW (case is Corsair 780T, good airflow)
At idle the fans still doesn't spin, hitting up to 40c. After playing BF4 for a few minutes the fans go up to 1700~1720rpm at 67c, doesn't go above that here. This is without any custom fan curve and just letting the card handle the temps/fans by itself.
I believe it can go even higher if you have a small case or not so good airflow but for me at least the fans are quieter and slower than selecting the aggressive profile manually.