In any case this is just your opinion, the fact is many people seem to prefer iPhoto to Photos.
Personally, I also prefer iPhoto to Photos, but that does not change the fact that Photos is more powerful both as a manager and as an editor and at integrating with other applications.
I also preferred to have Aperture available.
All that is required to have both of these apps available is that you have an up-to-date version associated with an App Store account.
"There is no app that can give you continuity for your books or other print products."
Well that was a pretty dumb decision and is certainly user unfriendly!
Tell Apple. I'm just telling you what your options are for migrating. In the case of book, there aren't any. Now you can remove that from your considerations.
Sure I use Lightroom but iPhoto was used in a different way for different purposes.
So you're using iPhoto, Aperture and Lightroom? Three different Photo Managers? Makes as much sense as three address books, but whatever. Really, pick one horse and ride it, would be my suggestion. In all that you mention, with iPhoto and Aperture EOL'd, simplify your work flow and move to Lightroom.
Actually the app iPhoto was useful for as long as I did not upgrade, i.e. until just now. And apparently other people have managed to install a version of iPhoto 9.6.1 that works on El Capitan and Sierra. So your statement is false
Perhaps you need to re-read what I wrote. I know it is possible to use 9.6.1, that's what runs on this machine right now. I even told you what's required to get it:
If you have a version of iPhoto v9 (sometimes called iPhoto 11) associated with an App Store account then you can update easily, like everyone else.
Which part of that is false?
If I knew that these iPhoto, Aperture and Mail would create a mess for me to clean up I would not have bothered updating, and left this as an non-internet machine.
You had 18 months to check, really. There has been plenty of warning. Apple announced that both iPhoto and Aperture were discontinued in June 2014. Really, it is a pretty basic thing to check this sort of stuff before updating.
That said, you made a back up before updating, right? So revert. Problem solved.
I suggest Apple have a careful look at user attitudes to "upgrades" where it is becoming clear "upgrades" are more like 1 step forward and 2 back. Where purchased apps become inoperative without warning and on balance the "upgrades" offer very little to the user but seem to be mostly about Apple sucking more user data back to Apple.
Make you suggestions to Apple here
http://www.apple.com/feedback/
but be aware that even though you didn't check first, an upgrade path was available for purchased apps, as for "very little" offered, you can review what is offered and choose to upgrade or not. But again, Photos is a far more capable app than iPhoto.
I do have an appropriate version if iPhoto, but it does not show up in the App Store
Assuming that you have checked the Purchases list, then it is not an appropriate version, but one not associated with an App Store Account. Again, the process for doing this began back in 2012 IIRC. Some folks have contacted the App Store and explained their situation and have been given download links. You could try that too.
In summary, you need to take responsibility for your part in the situation. You chose to upgrade without first checking the consequences of that. You choose not to use the replacement - offered for free, and more capable - as is your perfect right, but those are your choices. This situation has been evolving since June 2014, when Apple announced the discontinuation of the apps. They're a dead end now. Sooner or later you will migrate to another app. Why wait any longer?