Query used:
(node[highway=street_lamp]({{bbox}});
way[highway~"(unclassified|residential|primary|secondary|tertiary|[a-z]+_link|trunk|motorway|living_street)"][lit!=yes](around:35););
out geom;

Has false positives in terms of streets that branch off near where a street lamp was identified but that do not have street lamps mapped along them, so it needs quite a bit of manual checking