Is it worth doing any work to it as an "owner", possibly me going the property management way, or just stepping away from it entirely until the deed transfer?

At death, the property gets a stepped up basis.  

This is ideal for those taking their first steps in Spain or needing to establish a presence without having a physical office.If the goal is to link an SL with a holding or manage dividends, then yes, it’s essential to ensure the legal structure is well-defined and compliant with the relevant regulations.

I absolutely target retention through many methods.

While I didn't want to stay there permanently, it was a stepping stone to build my track record. 

Are there specific steps or systems you follow to ensure it’s done correctly?

You can also leave out some bulk hotel toothbrush/toothpastes, make up removers, earplugs, sleeping masks, etc. if you really want to step up a "In Case You Forgot" basket.You can keep a closet with extra of things that has a lock on it and if someone is irrate because they don't have enough pods, you can at least have a back up solution for them if you choose too. 

Taking it one step further - have you ever been open to negotiating with prospective tenants or tenants who want to renew?

However, you may be able to get the property at a discount, step in, and solve the problem.

Joining BiggerPockets is a fantastic first step – it’s where so many great real estate journeys start.