You have partly answered your own question. On a pre-made array you are limited to interrogating your sample for the content that is already on array. In case of small RNAseq you won't limited by that constraint (but may have additional experimental consideration to think about e.g. libraries). That said, if you are only looking for "known" elements already on the array (and cost, as always) you may decide to go that route.