I ended up disabling the default config and then manually adding each one except ssdp and zeroconf. Once I did that the huge number of look ups disappeared for me. But I don’t really like having to disable the default config to do it, since it may change over time. So that part of my configuration now looks like this:
# default_config:
# Contains these (as of May 2024)
assist_pipeline:
bluetooth:
#cloud:
conversation:
#dhcp:
energy:
history:
homeassistant_alerts:
logbook:
media_source:
mobile_app:
my:
#ssdp:
stream:
sun:
usb:
webhook:
#zeroconf: