We got Thomas trackmaster for DS when he was about 23 months. It took a while before he would stop stomping on the tracks, but I guess they are reasonably well make, because none cracked.
Maybe not as nice as some wooden train sets, but much cheaper and the motorized aspect thrills DS to no end. I think we bought the starter set for around 50 bucks or so (some track, accessories and one or two trains)
They don't make noise per say, just the sound of the motor going.
Hours of fun.
We add on to it as we can afford, and there are some good deals on used trackmaster stuff on ebay. My whole basement is pretty much one big train set now.