Yes, the external boot SSD option is definitely indicated. Your current mech hard drive is doing this:
Performance:
System Load: 1.54 (1 min ago) 1.64 (5 min ago) 1.75 (15 min ago)
Nominal I/O usage: 0.57 MB/s
File system: 48.68 seconds
Write speed: 63 MB/s
Read speed: 43 MB/s
The speeds for the least expensive USB3/SSD option will be 400MB/sec. It will feel like a newer computer.
The external SD makes sense in this case because when you move to a newer computer, the external can be used for extra storage or backups on the new one. Retained value.
That is the only pay-for option that passes the financial sniff test in your case. Your iMac was never going to be fast anyway. It is the crippled educational/institutional model with downgraded hardware to be attractive to cost-conscious bulk purchasers.
In addition to the slow mech hard drive, it has a laptop-class 2-core processor running at 2.3 gHz. The base consumer model the year (US$200 more) came with a desktop-class 4-core processor running at a minimum of 3.0gHz. These benchmarks from the MacTracker database give a scale of the performance reduction:

This forum article describes photanalysisd and how to manage its mega-maniacal tendencies:
https://apple.stackexchange.com/questions/310594/what-is-photoanalysisd-and-why-is-it-using-77-of-my-cpu