Anything which is front ended by a CDN tends to end up faster than your connection for even the fastest connections. That leaves most of the web, updates (Microsoft/Apple/Google), content services like Steam or cloud storage/backup providers, and centralized piracy like Usenet (decentralized like torrents obviously vary per the seeds for each torrent).
It's certainly convenient my games, AI models, cloud backups, and large file downloads tend to go many times faster than when I had gigabit but I'd by no means be crying on the sides of the road about how long things take to upload/download if I had to go back.
The biggest thing you'll run into is algorithms designed to increase performance for limited connections don't scale infinitely. E.g. updating games on the Epic Games Store tends to be core limited (even on an overclocked 9800X3D) rather than bandwidth limited because it puts so much effort into the encryption and differential updating with the assumption "it'll be fast enough to not worry about". Even in those cases... it's nice to max them out without even having contention on everything else you're doing.
It's certainly convenient my games, AI models, cloud backups, and large file downloads tend to go many times faster than when I had gigabit but I'd by no means be crying on the sides of the road about how long things take to upload/download if I had to go back.
The biggest thing you'll run into is algorithms designed to increase performance for limited connections don't scale infinitely. E.g. updating games on the Epic Games Store tends to be core limited (even on an overclocked 9800X3D) rather than bandwidth limited because it puts so much effort into the encryption and differential updating with the assumption "it'll be fast enough to not worry about". Even in those cases... it's nice to max them out without even having contention on everything else you're doing.