Cyclopentadiene/etc. hydrophobicity after nitrogen atom substitution at a double bond?
The cyclic unsaturated imine (Schiff base) will be more hydrophilic for the nitrogen lone pair hydrogen bonding and being a Lewis base toward water.  You do know that CpH [4 + 2} Diels-Alder reaction reversibly thermally dimerizes, right?  The endo-dimer is an exo-flip then hydrogenation away from JP-10 cruise missile fuel.

The cyclic imine, ${2H}$-pyrrole is an isomer of pyrrole.  One expects it will be labile toward proton migration in base.

http://www.chemspider.com/Chemical-Structure.7330.html 
http://www.chemspider.com/Chemical-Structure.5256848.html 
Click the Properties tab, etc.