I have Weetabix every morning with lots of cold milk and a bit of sugar sprinkled on the top. Haven't tried it on ds yet, not sure why? He's a porridge boy, but I don't see why he wouldn't like Weetabix.
Karen, the texture depends on how long you leave it in the milk, but I wouldn't be brave enough to give it as a finger food - it goes far too mushy. I think if you served it with enough milk, and mushed it up a bit, then it would be great as a smooth cereal-type thing for a spoon-feeding.
One word of warning though, I'm sure I read somewhere that you shouldn't give it to los before they were a year old - the wheat is quite course and could be too harsh for little tummies, that's why they recommend you stick to baby cereals until they are a little older and can handle it better.