Edit mode to video - can I change it so it follows the end of the clip?

You could make a macro. Not in front of my DAW but: Select audio event, then…

Locators to Selection
2 (on number pad or go to right locator–or end of audio event)
Set snap point to cursor

So you could do this with one key stroke.