how can i use python to ..upon opening a map,center (pan/zoom) to an event ( a point drawn by a X Y Coord. in a table kept in the map) and set the extent of that in data view to 1:10000?
If everything is already in the project at the desired location and scale... save it as a bookmark... then save the project.
When the project opens, everything will be as you left it.
However, I suspect that what you really want is a script that takes user input for some point coordinate, then zooms to that location and scale... that is a separate beast.
You could try an application extension, which as I understand it will listen for events like opening an MXD and then execute some logic, which could include what you mentioned.
To zoom to your feature, select it using Select By Attribute and then use the zoomToSelectedFeatures method of the data frame object.