We last went to Macau just before our son was born (over 16 months ago) and it was the first time I had been since the casinos had been built....I have to say I don't like it as much.
It use to be great for a quiet getaway....somewhere in contrast to the noise etc. of HK...but now Macau is just busy, busy, busy with tourists, traffic and construction!!!!
If you are not into casinos and gambling I wouldn't go.....I mean you still have the same old buildings, restaurants etc. but am not sure how much appeal they would have for children.
The Westin resort is geared for kids but for is a bit of a trek just for one night.