If you already have a Bachelors but love MI, is it better to commission, or go Warrant, or become a civilian?

After speaking to my Commander, I've been overwhelmed with career options lately so I wanted to get more opinions.

I'm 28yrs old and have been serving for roughly 2.7yrs. Just became an NCO last December.

I love military intelligence and wish to do a job where I can be rewarded for learning about culture, history, foreign politics, and military capabilities. I've been told to go intel warrant or become a civilian again.

I have a bachelor's degree from an extremely expensive and tough university (Carnegie Mellon). However, I didn't do so well because I was young and stupid. I worked a corporate job in audience analysis in Hollywood for a few years, but had no direction in life so I enlisted because I wanted to guarantee MI. Currently pursuing a master's in data analytics.

I am now an intelligence advisor in SFAB and I love it when I get to do country overviews and intel work, but I have MAJOR college debt (though great credit) so money is an important factor.

To be honest, though I'm good with academics, and I help the LTs with their homework, I'm not much of a Soldier (hate the field!) though I love military history and strategy.

What I wish to ask this community is, what career path offers a good balance of engaging intel work, good pay, and personal time?
I know you can't have it all, but looking for a decent balance.