Sphere colliders of 2 actors from the same blueprint not detecting actor overlap. What's going wrong?

Make sure you have the collision settings right. You need to enable collision (Query only if you’re not using physics, Query and physics if you are). Then you need the collision channels to match. For one component, the object type of the other must be set to “overlap” and vice versa.

For a step-by-step, there are plenty of resources explaining this, including video tutorials. Just do a search. I did a quick check and found this (Collision Filtering - Unreal Engine). It looks like it lays out the basics.