The sweet spot is opamp and application dependent. In your example, the opamp has to drive 1 Ohm load. Normal opamps will not do that, that is way too much current. I assume, you want this for audio. Most audio opamps are designed for 600Ohm load or 10Kohm load, headphone amplifiers can be lower than that. You will have some load on the output, but if you connect this to the input of an other opamp, than the load is basically 0. Than depending on your taste, you can make your feedback 10K, or even 600 Ohm. Also, look into the THD+N/load graphs! The higher the load, the bigger the THD. So you dont want to decrease the resistor noise when it will significantly increase the THD.
If you are looking for the least thermal noise possible, I've seen suggestions to parallel circuits. Not opamps, the whole circuits have to be paralleled, and the output is summed. I suspect cheap 5532 circuits outperform more expensive opamps in terms of noise, but I've jet to meet real data (Douglas Self doesnt count).