My son and I spent some time making custom weapons and the like using a tool called Bridge (https://bridge-core.app/). It's definitely not as powerful as modding once was in the Java version of the game, but you can do lots of pretty wild stuff with Bedrock if you're willing to jump through the hoops.
One "mod" that recently caught my eye was this one: https://www.youtube.com/watch?v=IUWRK0Jy9d0
Yeah, you have to buy it with "Minecoins", but I can't get too upset that Microsoft has allowed devs to monetize their efforts on the platform. There's still plenty of free stuff available and nothing to prevent kids (or adults) from taking a crack at their own mods.
My son was just recently playing with a site called Tynker, and without any help from me managed to get a custom item into the game, so if an 8 year old can do it, it's about as accessible as you could hope for.
I have always been put off by how commercial Bedrock seems as soon as you open it. But at the same time it sounds like interesting and official modding is available there.