For most U.S-VCs, I think a rough way to think about it is around Scale. If you are truly past Initial Scale (>$10m ARR) and have proven you can get to $100m ARR … say, you are at $20m ARR … no one is going to ask you to move. They might suggest it.
If you just getting beyond Initial Traction … $1m ARR …. 95% of U.S. VCs are going to want the CEO at least to move here.
The grey area is probably somewhere between $3m and $15m ARR. The VCs will deep down likely still want you to move. But if they can see you building a unicorn without doing so … they may tolerate not moving.