I know that it is never ordered to fast on any Sunday, not even during Lent, but if one wanted to, would it be good or would it be a bad thing?
A bad thing.
You have 6 days during the week during which you can fast all you want.
It isn't consonant with the mind of the Church to fast on Sundays. Sunday is the Lord's Day, when we celebrate the Resurrection.
I don't think the saints fasted on Sunday.
Just look to our Holy Mother the Church for advice on this matter -- she has periods of penance, fast days, ember days, but also FEAST DAYS where we are told to rejoice and be happy, to better honor Our Lord, Our Lady, one of the saints, or one of the mysteries of our Holy Faith.
You do realize, of course, that "doing what the others do" and "following the crowd" is virtuous and ideal, as long as those "others" are devout Catholics living a Catholic lifestyle. Being singular even among devout Catholics is a fault, not a virtue. It's a temptation rooted in pride.
There is a time to rejoice, a time to weep. A time to feast, a time to fast.
It's in Ecclesiastes -- inspired by the Holy Ghost. "The Byrds" even took those words and turned them into a song.
One last thing -- when it comes to fasting, you should always consult with your spiritual director. There is always a danger of vainglory, pride, etc. entering in to it. But never would the danger be higher than when you are tempted to fast on Sunday. Imagine what you would think of other Catholics who don't fast on Sunday... You'd be pretty much the only one. Imagine the temptations to vainglory you'd experience, unless you were in the advanced stages of sanctity.
In other words, there would be a HUGE danger of "singularity" or making oneself stand out. Singularity leads to vainglory, pride, and a Pharisaical scorn of our fellow Catholics.
The devil wants us to be proud and vain about ourselves. Some Catholics, giving in to this temptation, look around for "uncharted territory" for something they can do to make themselves singularly holy or even singularly Catholic! Fasting on Sunday sure seems to be a tempting target in this respect.