Here are the answers to your questions:
Concise French is not suitable for self-study, the grammar explanation is not detailed enough, and because it was written by China people, it feels like French in China. However, after learning the first and second volumes of Concise French, it can probably reach CET-4. His translation should be in the answer tree.
French of Beijing Foreign Studies University is written for French majors, which is more detailed than concise French. It is divided into four tutorials, step by step. But it is not suitable for junior high school students to study by themselves.
I'm afraid few people have seen the words "French for middle school students" and "French for hard work" you asked. Judging from the title, it should explain the most basic French grammar. In fact, it is better to learn a foreign language simply at first, and the grammar book should not be too comprehensive, because it will increase your burden and have a negative effect on learning.