This works as expected:
aws s3api list-objects-v2 --bucket spinhead --query "Contents[?StorageClass == 'STANDARD'] | sort_by(@, &Size)[-3:]"