Well, I guess there is no way a queen sacrifice can be compensate by static evaluation even with attack table.
Maybe simply not applying LMR on moves that are checks may help to find tricky wins.

Yes, in that kind of position, an average human chessplayer (around 1800) can be superior to an engine rated 3200+.
That's really a weak point of current engines.
As a human thinks : "1) hmmm, this queen sacrifice attracts the king in a dangerous area where my pieces control a lot of squares. 2) Let's verify if I can mate this king there. 3) yes, I see a forced mate : 1-0 "