We love Artists' Point, and we *try* to fit it in on every trip.
My son, who is now 11, has been going there since he was 6. Like every WDW restaurant except V&A, there are always children of a variety of ages.
The ambiance -- it's not super fancy. It is much prettier when the sun is still out -- the views out the windows to the little creek/waterfall (that runs from the lobby to the pool) are pretty, but once it gets dark that feature is totally lost.
We love the food. We really love the cedar plank salmon, and we've enjoyed the other dishes we've tried.
The Wilderness Lodge itself is lovely, and very fun to walk around if you haven't been before. You can take a boat from MK or from the Contemporary, which adds a nice element to the adventure.