I've always urged my parents to buy extended warranties on their cars, for multiple reasons. They don't maintain vehicles properly. They tend to buy Chryslers and Fords. They can't fix anything themselves (and don't believe in my mechanical abilities, even though I've maintained all my cars myself for years).
For example, their '98 Caravan has been a piece of junk. They bought it with 36k miles. Head gasket went out at 38k. Tranny went around 60k. Starter went at 65k. The list goes on. For them, the $900 extended warranty was very worthwhile.
I just bought my first Honda, an '01 Ody EX. I bought said van because it's a Honda and thus should last a long, long time. If you buy a Honda you're already paying a premium for the reliability history of other Hondas.
Knowing that the transmission is automatically extended to 100k miles made it an easy decision for me to NOT buy an extended warranty, or even pay a premium for a certified Honda. I've spent about $200 and one weekend doing a more thorough check (and maintenance) than any "certified" Honda would get (replaced plugs, filters, fluids, brakes) and I bought it for thousands less than a comparable "certified" Honda.
So, only you can answer whether or not you should get an extension. Peace of mind = piece of wallet
The price for the vehicle you're considering does sound reasonable. If you like it, can afford it and are comfortable with the vehicle go for it!