Fixes #17384 Bypasses enabling off-strategy storage/placement for repair streams when table repaired is using tablets. Instead, the resulting sstable(s) will be placed in the "normal" set of sstables, and bypass a post-repair off-strategy compaction. v2: Bypass off-strat for whatever reason iff dest is tablets. Closes scylladb/scylladb#27500