Something that aged poorly are browsers. Can you run contemporary Chromium, Firefox, WebKit decently on a 800mhz G4?
And I doubt it could handle more than a few open tabs with 512MB of RAM.
Most everything else I use computers for have been fast enough for 20 years or so.