Haha yeah, I do that for me. My VIP contacts have a different ringtone and Messages sound.
I didn’t realize how bad my alert/notification sounds fatigue got until I realized that a coworker’s (in an open office layout) phone was the same brand as the office fridge (so his notifications made me get up to check if the fridge was left ajar) and his home doorbell was the same sound as the office doorbell.