At the first glance the statistics look way off, have those been updated recently? Further the index seek on [TRAFFILOG_GEO].[sys].[extended_index_2066106401_384000].[TBL_STREET_ROAD_NEW#ISRAEL_geom].(Spatial) is quite hefty, are you using FORCESEEK? A range scan would probably be more efficient here.

😎

Last but not least, as I mentioned before the geometry data type is not the correct spatial data type for this, geography is.