I was trained in cold water and like it a lot better. While I don't get as much mobility and flexibility because of my gear, I'm more in love with the kelp forest and rocky environment.
For me diving through a kelp forest is a lot more fun than diving through a sparse coral environment, where the only noticeable thing to see, is more often only below you.
What you should expect with cold water diving is having more gear and weight on you. You'll HAVE to tighten all your straps including weightbelt and cumberbuns as you descend. Because as you descend your heavy weightsuit will compress and all your straps will become loose.
Your air consumption will probably rise, and you may be very cold during your first series of dives. But if you keep diving in cold water you do get used to the cold and you won't notice it as much over time. Getting a very well fitting wetsuit will help this all the more.
All these things add new concepts that you'll have to experience to understand, sometimes it can overwhelm you. So I suggest doing a very easy novice dive for your first few coldwater dives.
Overall it is very fun. I prefer it, others don't. Give it an honest try.