Well I suppose condas are good snakes for the right owner. The yellow ones are stunning and if you get one this small chances are it will settle down very well.
But they will always be snakes, if a corn can have a bad day, a conda can have a bad day too.
The most important I think is that the owner should be very aware of its needs, and provide them with planty of space and water, they love swimming.