To note, you don't have to isolate yourself to manual focus - there are to manual to autofocus adapter for the Sony E mount. Indeed, there's the original Techart LM-EA7, as well the much cheaper knockoff that is the Fotodiox Pronto. As far as I know, this is one of the few instances of an American knockoff of an innovative, expensive Chinese product :). The knockoff is so egregious that it actually can use firmware updates from the original.
If you do decide to go with the knockoff, it's only about 170$ to make your manual lenses autofocus, though it's slightly slower than native and doesn't work in video. It can't completely autofocus lenses longer than 135mm, so if you're shooting telephoto you will need to focus very roughly and then it will correct it.
I picked up a 50 mm f/4 Macro Takumar for under $100 on eBay. I already had a couple nice Takumars and SMC-M primes that I can keep using. It’s awesome.
Granted, I’m shooting furniture under continuous light. It’s not a super demanding application. If I were a pro photographer, I’d probably be shooting the same kit as everyone else for the same reasons.