I'm going next week and I'm bringing my dSLR and a few lenses, as well as my Diana+ film camera for some fun, retro looking pictures. I'll be wearing my Northface backpack with all of my gear in it. I'm even going to lug my tripod around when I go to EMH in the MK next Sunday night.
For those looking into dSLR cameras, my advice is this - buy it far enough in advance of your trip so that you can learn to use it. What I think some people don't realize (at least some people I know personally, myself included a few years ago!) is that just having a more advanced camera won't make the pictures come out better right away. There are auto features on a dSLR, and they come in handy sometimes, but if you plan to shoot auto, you're not taking full advantage of what the camera can do and might as well stick with a less bulky camera. 10 megapixels vs 15 mp doesn't make too much of a difference if you only plan to print out 4x6's or upload pictures to Facebook. The good thing about point and shoots is that they do they hard work for you - exposure, aperture, focus, etc. They even sharpen for you which is something a lot of folks using dSLRs do later in post-processing. That said, if you are the slightest bit interested in improving your photography, I absolutely encourage you to get a beginner level dSLR and play around with it. Read up on how to use settings, and practice, practice, practice. Point and shoots can only do so much - and from what the OP has said: "maybe it is just me, my little point and shoot Canon SD600 seems to only handle daytime and bright background pictures fine but at night or indoors or objects in distances it produces very dark image...", it seems like you'd really benefit from the manual functions of a dSLR. Longer shutter times, wider aperture, etc. This post was my really long way of saying that a dSLR is worth the money so long as you learn to use it outside of auto mode, IMO.