Apple ID password vs iCloud password - better to be the same or different?
First, you usually don't need a different Apple ID for iCloud:


  We recommend that you use the same Apple ID for Store purchases and iCloud. Using multiple Apple IDs might be confusing and might cause issues with accessing purchased content or using some services.


If you do have two Apple ID's, Apple has this to say about reusing passwords:


  Avoid using your Apple ID password with other online accounts.


Password reuse is problematic because all your security depends on the "weakest link", the less secure –or more exposed– service. Once that service is compromised, all your services are.

XKCD has this to say about the subject:



On the matter of remembering passwords, XKCD –sorry, again– has some iconic graphical input, analyzed and validated here by the people at InfoSec SE.



In a nutshell, passwords must be difficult to guess and easy to remember, and he proposes the use of passphrases instead of short, complicated passwords.

Yet others think that 


  The Only Secure Password Is the One You Can’t Remember


which is my philosophy by the way.
In order to achieve this apparent nonsense, you use a Password manager, (iCloud Keychain, Keepass, 1Password, LastPass), and generate different random secure passwords for every service. You only have to remember one master password –where you could apply XKCD's idea.

People have different opinions on how secure password managers are; if you are a bit paranoid or have very sensitive data you may want to have an eidetic memory instead, although one known cryptographer and security expert advocates the use of at least one –not cloud synced, though.