it's not clearcut therefore i'd not advise to attribute any fixed mode to the prefixes

for example how would you translate "прописать" ? obviously not overwrite
overwrite is переписать
as "overdo" is not проделать, but переборщить

for the sake of the discussion oversleep can be translated as переспать that is 'to sleep a little too long, over the expected amount of time'.

проспать is also 'to sleep through' if it means 'to sleep during a certain event' like 'he slept through the entire episode' - 'он проспал всю серию'