If you don't want to start thinking about noise reduction PP, I stick to 400 and below.
800 is workable with a few cleanups.
As for noise "being a problem", it depends on whether you are creating art or just as accurate image as you can of a subject. Noise can easily be part of an arty shot but really spoils a shot that is just supposed to be glossy image.