Is this stuff… like, good? I don’t know anything about the MS ecosystem. If you could start from scratch, would using something more like Python, pandas, that sort of stuff, be viable?

You're not going to get non technical coworkers like the finance department entering their data or reports in pandas. So it depends on how much labor you want to put in helping them do it, I guess?