>Secondly, I also want to equip myself in the future in the event I change jobs or possibly start working for myself that I can ready equip myself from designing all the way to prototyping and be efficient in doing so.
This is why you should do it. If you are curious about it, and can have this financed. What you learn (regardless of machine) will be yours, and could be a useful thing going forward.
Regarding the 0201 and 0.35 BGA - I think actually many machines can do this, there's even that guy that modifies 3d printers and with the "lego" build setup that does 0201. Granted, slow and so on, but still.. But no, for all sorts of reasons, I would not consider doing boards like this myself, mostly because of the paste printing, as has been mentioned. Maybe an odd 0201 here or there, but I doubt I'd want to do it in too many boards.
Large (long) higher density connectors are worse for the pnp machines, in my experience.
Expect to nudge few components here and there, especially with such small small series there will be few iterations to tweak. But this is manageable, and beats hand placing in every way, anyway.
I can say that for me, the learning curve was steep, when I bought a used machine, and converted it to opnenpnp. At times, I thought about giving up. But now, I fully enjoy making boards, and like the flexibility it gives me,
I have (for now at least) set a limit of max 1000 boards/yearly on my machine - if it goes higher, I'll subcontract. Mostly because of purchasing and planning time, that I totally underestimated, coming for larger companies, starting my own business (as a recovering workaholic), but also, because I don't want to spend more than a few days a month doing this type of work.