So MTB shoes are built for offroad use- my experience has been that pavement kills the lugs pretty quickly. the harder plastic of more expensive racing shoes seems more vulnerable to this, so you might actually be better off with some lowly shimano shoes or whatever. i've worn out spds and time cleats as a result of this wear and have had to deal with accidental clipout as a result. it's never been that bad- i've always been able to deal with it in time. even pulling out at the brooklyn base of the north side of the williamsurg bridge path with snow on the ground, back when that was open, wasn't a huge problem. certainly taught me to push more than pull when skidding.
to address the original post- spd cleats wear less than time cleats. i switched back to my 747s because of the wear on my atacs. the first thing i noticed was the lack of float- i'd unclip in the middle of traffic just from flicking the back end of the bike around. i was twisting my shoe more in the atacs and on the spds my foot would just fall out of the pedal (it felt like a really gentle, barely noticable unclipping).

right now i'm thinking about going to toe clips cuz food delivery sucks on slippery sidis.