Specifically on Rockets:
Yes, CP3 and Harden both are best with the ball, but it will likely work because:
a) they are the best passing duo in league history by a wide margin
b) the Rockets will play fast enough that they will both get the ball plenty and there will be enough space for guard to guard passing early in the offense.
c) the Paul/Harden P&R should be completely unstoppable. Paul commands almost as much attention as Curry coming off a high screen and Harden has the size, scoring, and vision to play the Draymond role, but better.
Also, Nene, Tucker, and Gordon is a very good bench. But yeah, they have nothing after that.