Textbook publisher offers to pay me for a comparative review of textbooks
I see nothing fundamentally unethical about this. It would become unethical if the request included a requirement that you adopt a particular book, or that you write something that pleases them. But by itself, requesting a review and paying you for it does not seem wrong to me -- they may simply be interested to hear from people in the trenches how these two books compare.