The part that is hard to really convey is just the fun of it. Being able to run a log dive to grab some data using standard grep/whatever, then to immediately pull it into either R or Python or just Gnuplot to get a visual is quite a nice trick. Top it off with a quick export to pdf/html/markdown to send to someone to confirm it. (Typically a stakeholder.)
Add to this emacs TRAMP capabilities and I just need whatever tool I want on a machine I can ssh to. Don't have a good install of python locally for some reason, just set the :dir attribute of the block to my machine (or docker container. Or a series of jumps through combinations!) that has it, and I'm good.
It does have some growing pains sometimes. I found that the SQL plugin didn't do the passwords as I wanted it to. But, that was a simple breakpoint and hot code fix away. (I, regretably, did not prepare a patch to send upstream...)
The problem with spacemacs as a beginner is it isn't quite emacs, and it isn't quite vim, and as a beginner you don't know how to translate vim and Emacs guides to spacemacs.
Main advice I have, that I don't think I really followed, make time. Literally pick some time to do something you were going to do anyway, but that you aren't in a rush to do. Preferably not on any critical path. It will be slower.