Honestly I almost wish my whole life could be on my Mac mini g4. I wish Apple had loaded it with a fx5200, but it’s otherwise great. I think I wanna put FCP 5 or something on it. The critical part to remain connected is the community port of 10.4 fox which if you have time to compile gives the machine a shocking amount of functionality. The key is to work with it’s limits. 10.5 has a really great version of libreoffice 5, you can use it to browse anything except YouTube, and if I got a usb drive for my iPhone I could even share videos and files, long as I turn on h.264 haha. Getting work done doesn’t mean google docks, and frankly I’d rather use a desktop app anyway. I don’t like the move to the web for everything and I actually want to own my software, not rent it. If I need to share something via the net, hotmail likely still works, iCloud did at least until it was updated, and I’m sure I can convince OneDrive to work though I have not tried. I don’t need to share files with anything outside my home though and I also have a 2012 Mac mini running Mojave that is honestly my main Mac.
Anyone willing or wanting to use a ppc Mac as a work machine will need to recompile TFF from source once a year, run libreoffice, or iWork 09, and use 10.5.8 or likely sorbet leopard. Of course for videos and photos it works good. Save your self some trouble and while you can edit videos and export them on a ppc upload them using a raspberry pi or iOS device. Of course resolution and such come in to play, I find 720p best on my Mac mini in iMovie HD but others can run whatever they can handle. A dual g5 can do 1080i or p30. Computers remain useful tools within reason and ppc late models from 2005 are shockingly so. Online collaboration and working tools require more cpu power and may be doable on a g5 more then a g4. I have not personally tested google docs Or Google drive but maps work, and you can always upload And download files in any number of formats using secondary or tertiary devices that are plentiful and cheap. Libreoffice really is great and was last updated in 2016 for leopard.