This is how I feel about pretty much all the most data-hungry services. It's never been about an improved use experience, because the quality is not there.
I can't count how many times I yelled/cried about Spotify trying to learn every mood I've ever felt (and what song would have been perfect for the moment!) only to play the same 4 songs over and over because I listened to one of them on purpose a week ago. (I no longer use Spotify. We'll see if Tidal falls into the same trap.)
google assistant is probably still not Bard powered, so it just means someone didn't coded some rule: user asked "closest one" -> locate user location -> locate home depot closest to that location