Earlier quoted context omitted.
I can't imagine ANY reason that a private household would actually need a 10G or 25G connection unless it's doubling as a workplace and they're hosting servers. Even that seems like a temporary stop-gap situation, get some rackspace in a datacenter already! Maybe they're not selling enough 25G to their business customers and they're trying to get private users onto 25G?
For download? Working from home with large media assets of any sort. For upload? Yes, I need ANYTHING faster than Comcast's BS so I can actually do any work OR even backups without killing my ability to do other things.
Bu can you really make use of 25G or 10G service to the point where 1G is unacceptably slow? Probably not. It would strongly depend on the bandwidth of whatever you're connecting to.
As a deluxe nice-to-have with bragging rights, sure, but it won't make an operational difference except in very specific scenarios that almost no household would actually need.