NKJV, ESV, and NIV probably in that order. They do a limited amount of memory work in the KJV for homeschool.
I was thinking that if you said CSB, there is no shortage of Study Bibles in that version, although I am not familiar with the ones aimed at children. The Spurgeon Study Bible (CSB and KJV) is very good as far as it goes, but sadly that isn't very far in my opinion. What content is there is great, but the majority of chapters have no notes. (Since he wasn't an expository preacher, I suppose that's not too surprising.) Some of the others I'm familiar with, such as the Worldview and Apologetics Study Bibles, probably wouldn't qualify as "devotional."
For various reasons, I've soured on the ESV in the past decade, so I'm not that familiar with options there other than the ESV Study Bible, the MacArthur Study Bible, and the Reformation Study Bible. I do know that they have a good many "student" Bibles designed for various ages.
Likewise, with the NIV, I'm only familiar with more prominent ones like the NIV Study Bible, the Biblical Theology Study Bible, and the out of print Spirit of the Reformation Study Bible. I've looked my old NIV Study Bible recently and it is better than I remember. (I'm referring to the one edited by Kenneth Barker which was originally published in 1985 and which has gone through several editions, not the newer one edited by D.A. Carson, which was first published as the Zondervan NIV Study Bible and later renamed the Biblical Theology Study Bible.) It has a mix of doctrinal and devotional (or application) notes. I think it is probably still pretty good as a "training wheels" Bible and is more than that. But unless you go hunting around for used copies, it is only available in the NIV11. It wasn't designed for children, but neither was the Life Application Study Bible.
There is no shortage of Study Bibles in the NKJV as well. That's probably one reason why sales of the NKJV haven't dropped off further in the past decade. (It used to be #3 consistently on the sales charts, now it is usually around #5.) The Holman NKJV Study Bible (not to be confused with the one by Nelson) is more or less in the same vein as the NIV Study Bible and was based on their HCSB Study Bible. It is more "devotional" than something like the MacArthur in that it is less in-depth. Like other Study Bibles that are in what I term the "General Use" category, it contains a fair amount of historical and geographical material. But that could be a good thing even if it isn't strictly "devotional." Beyond the educational value of that, it may serve to better engage the reader, whether a child or an adult. "Well it says the Israelites fought the battle here or there. Oh look, here's a map right here in the text that shows where that is." "Ooh here's a picture that shows what the temple looked like and what the priest wore." As you may have noticed, these kinds of Study Bibles now include full color pictures of the type you'd expect to see in a Bible Dictionary or Encyclopedia in the past. That may help to build interest too. Being produced by a Southern Baptist company, it is Baptist broadly speaking. Some of the material probably isn't incompatible with covenant theology, although it certainly isn't taught. There are hints of dispensationalism here and there, but the notes in other books are clearly incompatible with that. (The Nelson NKJV Study Bible was produced by men who are all or almost all dispensational. I've only glanced at it and they nonetheless seem to have sort of tried to keep it in the middle of the road, but I think the Holman is probably preferable.)
I don't know what the theological position of the Life Application Study Bible is. (I have one boxed up, and I've barely cracked it open.) My guess is that it is probably sort of lowest common denominator evangelical, and probably not particularly friendly toward covenant theology or Calvinistic soteriology. I can't remember who any of them are in particular, but when I looked at the contributors, to my recollection they represented a wide variety of denominations. So with that in mind........
A good Study Bible that fits into the "devotional" category (at least as far as I'm concerned) is the Wiersbe Study Bible, which uses the NKJV. Warren Wiersbe was a dispensationalist to be sure, but I don't think that can be seen in most of the notes. He was also fairly Calvinistic, basically what most here would term an Amryaldian. He doesn't seem to have been into "easy believism" either. Others may disagree, but I think that's probably preferable to a lot of the other Study Bibles out there. Most of the notes are practically verbatim from his commentaries. If you can eat the meat and spit out the bones, arguably it is better than the Spurgeon simply because there really isn't a whole lot of material in the Spurgeon.
Unless maybe it is among the plethora of Study Bibles that I've written off as superficial (if not filled with bad theology) I can't think of anything in the devotional category that is worth a look besides the Spurgeon, the Wiersbe, and the RHB KJV Study Bible. But maybe the Life Application is a lot better than I imagine it is.
The best website to shop for Bibles is probably Christianbook.com since they generally have everything that's in print, probably have the best Bible specific search function, typically provide more information about a Bible than other sites do, and sometimes have a better preview than Amazon does. The prices are competitive and are frequently cheaper than Amazon.