Here's a rough description about how I do use the range of early macs in my working environment (bold topics are the essentials):
68k (experimental)
early MSOffice / AppleWorks 3-4 / Print2PDF
Database
68k fun-stuff
reduced connectivity: FloppyDisk, PCMCIA/CF-Card; LocalTalk(Hardware)/AppleTalk(protocol) [...]
PPC os9
MSOffice'01 /PDF
Database, Fax-machine (FaxSTF)
very basic web (Classilla)
image-editing
very low-res video editing (experimental)
os9 fun-stuff
Connectivity: IMAP, webDAV, FTP, AFP (up to Tiger/Leopard), VNC
PPC OSX
MSOffice '04/'08 / PDF
Database; Fax-machine (PageSender); DEVONthink
normal-speed scanning & very slow OCR
basic web
basic 480p-780p video streaming (YouTube); no streaming-services
image-editing
low-res video editing
PPC/OSX fun-stuff
IMAP, webDAV, FTP, AFP, SMB, VNC, ScreenSharing, RDP
VM: Win2k (ok); WinXP (distressing)
OSX: Tiger/Leopard
"early" early intel (core-duo/core2-duo)
MS Office '08, LibreOffice / PDF
Database / DEVONthink
normal scan & slow OCR
normal web
video streaming (web-streaming services, up to 1080p - no 4k)
image-editing
reasonable but slow HD-video editing (no4k)
IMAP, webDAV, FTP, AFP (modified down to OSX 10.5), SMB, VNC, ScreenSharing, CiscoVPN/RDP, Dropbox
VM: Win68/Win2k (fast); WinXP (bearable); Win7 (distressing); Win10 (possible, but unbearable)
OSX: SL // Lion // ElCapitan --- patched: Sierra // HighSierra // Mavericks
USB3 (through PCExpressCard)
"late" early intel (pre-retina i-generation) here: mid2012 x4 2,6GHz 15" MBP
+ fast OCR;
+ faster Video-editing
+ faster web / streaming-video
+ 4k-video
IMAP, webDAV, FTP, AFP (modified down to OSX 10.5), SMB, VNC, ScreenSharing, CiscoVPN/RDP, Dropbox
VM: Win10 (ok)
macOS (patched or supported): ElCapitan // Sierra // HighSierra //.Mojave (32/64bit)
USB3
So my wish is to have the "late"-early-intels (without soldered components/harddrive), e.g. the mid-2012 15" MBO included in a future early-OSX subform.
____________________________________________
my current no-go-area: Catalina(64k) / BigSur ...