I feel like DIO would despise/look down on Diego, like his goals are too superficial or because he is too human.

oh, he’d definitely look down on him, i dont think he’d despise him, merely just not acknowledge him. if they met i bet DIO would just fleshbud him to use him as a stand user