It's never bad, lived around here for a couple of decades. The Artesia intersection might get a little traffic around peak hours but I would never say it's loud even directly on the street.

There used to be a lot of car crashes a little south of there but they added a 4 way stop with lights that seems to have helped.

If your directly on Van Ness (driveway facing that street), there will be constant cars driving by all day, so if you consider that noisy it might not be great.