I had automatics my first three trips to UK and Ireland. On the next trip, only a manual was available, so I had to take it. I drove manual transmissions in cars I owned from 1967 until 2005. I used the car for a few days and never considered an automatic in Ireland or the UK after that.
In Australia and New Zealand, automatics are the standard.
I am pretty sure I will try a train to St. Andrews with a flight into Glasgow in the next few years. Having a lightweight standbag and rolling golf travel bag will make it workable. I live near Seattle and the Icelandair flight takes seven and a half hours to Reykjavik, has a 90 minute layover, and a flight of about two hours to Glasgow.
I've flown into Heathrow, stayed over near Kings Cross and taken a morning train to Edinburgh. Golf clubs went into the baggage car.
I also took a train from Heathrow to Paddington to Heathrow to Exeter, stayed overnight, and picked up a car in the morning.
My experiences with trains leads me to have a flexible approach. Often, rental car outlets away from airports are lower cost, by a sizeable amount, especially when three and four week rentals are involved.
Leuchars does not appear to have a rental car outlet. Cupar does.
The Inverness car rentals are mostly at the airport.
Charles Lund