Is it possible to specify

load_method

for each stream? For example I want one table to be overwritten every time whereas I want another one to be append-only

Not at the moment, can you give https://github.com/meltano/sdk/issues/1350 a 👍 if you'd like to see something like that.