My tractor has been some of the best money I have ever spent, and I use it all the time. A lot of the time, it is just a motorized wheelbarrow for things like
@knuckle47 mentions - so handy and easy to move bulky/heavy things around. I initially resisted spending the money for the front-end loader but the dealer I bought it from talked me into it, and I'm sure glad he did.
With all of the different attachments available, you can do so many things with them. You will always find a use for a brush hog and a box blade on the rear three-point hitch, and pallet forks on the front.
Buying second hand is fine with a good brand like Kubota; as long as it has been reasonably well maintained, they will last nearly forever. Kubota is like the Toyota of tractors - not the cheapest option, but the Japanese build quality is there.
Good luck in your search!