Thanks for the welcome, guys.
I'm surprised at the lack of a Sports/Overdrive button. Excepting my '86 Accord, every Japanese auto I've had has had one, even the Lexus. It's very useful when I want to turn the overdrive off for instant power; pre-empting an overtake, for example. I know I can drop it into D3 to force it to shift down, but I've just got used to using the sports/overdrive button. Also useful for a bit of engine braking.
(As an aside, the Sports, or correctly named, "Power" button on the Lexus changes the profile of the gearbox - it downshifts sooner and easier and holds on to gears for longer. If I drop it from "Drive" into "4", then the overdrive is off and it takes off like a bat out of hell. Combine with "sports" suspension mode for even more fun! With sports off, it sets the car up for cruising / comfort driving and doesn't like downshifting unless it really has to. Completely transforms the car).
The question about the manual box was me musing about a manual conversion if I ended up with a car with a bad auto box.
Question about the sports mode - Googling hasn't really helped me here, and aside from a few mentions on here, there's not much more to be found. Is it a genuine sports mode, or is it the car being more responsive and powerful because of the higher octane fuel? If it's a change in how the ECU allows the car to perform, then does it hit the MPG?
Speaking of MPG, what can I expect? Obviously it depends on how it's driven; I tend to drive pretty calmly but I do enjoy a heavy right foot when conditions allow. Late 20ies?