Lightening damage - any hope?

Sorry to hear that but it's good that the N200 and the amp were spared .   I have both systems isolated with fiber optic media converters.   I also did it to combat noise , I never thought about stuff getting fried via Ethernet.  

Hopefully your post will save someone that nightmare.  It's cheap to do,  in my main system I have a TP Link gigabit switch with 2 SFP ports one going to a TP media converter .   The second system uses a TP Link media converter on each end.   Cheap insurance and absolutely dead quiet digital

Apple TV box is disposable electronics at best.  Spectrum (bastards) will replace the cable box for free.  The router is likely toast.  I'd open up the Sony and Marantz and check the fuses in the switch mode power supplies with a meter.  The problem is that both those units are in constant standby mode, and hence susceptible to such problems.  Since the strike entered via the network ports, I'd say there's little chance of repair.

I would also go into your basement, and check to be certain Spectrum correctly bonded the incoming CATV line to your cold water pipe or ground rod.  If Spectrum failed to do so upon initial installation, you could get all your gear back and some.  

Most of the more valuable components should be able to be repaired. Keep in mind repair charges usually start at a few hundred $$, so some stuff might not be worth it. As others have said, do some basic diagnosis if you have not done that. Check for fuses and basics. If you are able to use a multimeter you can sometimes figure out where the current stops flowing. If the damage came through the network cable, might be a more difficult thing to diag, and we have had that happen in the past few years ourselves. I still have a HT receiver that no longer connects to the LAN due to storm damage. That said, most of my gear is behind a protection device that also protects the LAN connections. Internet gateway is on a separate UPS/surge protector. Lifetime Florida resident here, and have spent thousands at the repair shop in my life due to storms, and now my protection devices probably cost more than my first stereo rig! :-) Lessons learned the hard way.

Some units may also have internal fuses in addition to the Aac mains.   Might be worth taking the covers off what you can.