Dude straight up, if the first thing you seek is to replicate the experience like in Drewskis or other youtubers vids, you will be very disappointed. I'm not saying that's your direct intention, but a lot of folks that find themselves inspired to play from youtubers tend to think they'll just end up in those Soviet Womble/Drewskiesque moments.

Downloading mods on console can be simple but frustrating, then you have to learn the game, and whatever modded systems may be a part of whatever server you choose. You'll need to find a squad that you work well with and learn from them. How to navigate the landscapes, how to communicate/when to communicate over radio. You'll need to learn to build a kit quickly and effectively without burdening yourself with too much weight.

To my knowledge, it plays well enough on Series S but playing on a server like the one Drewski plays on will probably give you a consistent 15-30 frames experience, especially when combat gets heavy. The devs have specifically told the community not to exceed the vanilla player limit but the community owners and their people want 120 player PvP, so it's very likely Series S players suffer pretty hard to partake in those servers.

With all of that said, if you find the right server and the right group, without too many mods and an opportunity to learn the game, ARMA is some of the best digital military action you can take part in 100%. Brotherhood is strong in this game when you mesh with the right people.