I work for a medium-ish company (around 250 employees), and we're just a small team two devs, and a sysadmin basically and are pretty autonomous and there's no "up or out" expectation for anyone here.
There's definitely downsides - no one outside of our team has any technical ability whatsoever so communicating requirements back and forth is difficult, and a lot of the work is boring business CRUD and integrating SaaS products together, but it pays well enough and I love being pretty much autonomous on our small team. Most days it just fees like I'm a contractor.
All that being said, I'm almost 40 so I don't mind the boring enterprisey work. In my younger years this job would've burned me out super fast, just something to keep in mind.