API and ILSAC rank at the bottom. Oils that carry these specs (and nothing else) should be considered barely acceptable. The oils are the equivalent of D students (passed but only just barely).
I think what folks are pointing out is that API SN is not simply barely acceptable for those engines requiring nothing more. If the oil does the job for which it is intended, and the engine lasts 400,000 miles, how is that barely acceptable?
I think your analogy of an SN oil being a D student compared with BMW LL-04 being an A student perhaps is relevant, as long as you also define the tasks they are required to do. Both A and D students are capable of adding 1+1; neither gives you an advantage one way or the other here. Both SN and BMW LL-04 oils are capable of giving a GM Ecotec engine a 400,000 mile lifespan with 5,000 mile OCIs; neither gives you an advantage one way or the other here.
Now, if the task at hand is engineering an automobile, then you NEED the A student instead of the D student. Likewise, if the task at hand is lubricating a BMW V-10 engine in an M5, then you NEED the A oil instead of the D oil.
Like viscosity, oil quality grades/standards must be taken in context. BMW LL-04 oil offers no advanage over API SN oil if you're changing it every 5,000 miles in a 4-banger, and API SN is not considered just "barely acceptable" here.