What tense is 你会不会怕我?
The usage here is like 'would' in English. 'Would' can be either past tense, or present tense with subjunctive mood. 会 can be either future tense, or present tense with subjunctive mood.

I believe this usage is influenced by Taiwanese Mandarin where there's a common pattern to turn simple V+O structure into 有没有/会不会 + (V+O as O) to soften the tone. This is considered redundant and borderline ungrammatical in the schools in mainland China, but in daily spoken language it's very common.