dun cry... every camera has its limitations... even the good DSLRs. learn the basics and when you figure it is time... then upgrade.
my guess is that when you take night shots, they don't come out right... the "effects" that you are looking for. i went through that frustration when i was shooting my first night event. almost pulled my hair out!
one of the big things about photography is lighting. know where are your light sources, and how much light and where the light comes from to get the shot. it is always a challenge to capture the picture as your eye see's it... because the brain is the most sophisticated processor of light... far superior than any 1DMkIII or D3 (did you know if you wear a pair of upside down glasses, which inverts what you see, your brain after sometime will turn your vision right side up?).
because there is a lack of light in night shots, using maximum zoom to take a shot would come up awful. either your flash is not powerful enough to reach (and using a flash is another monster to tame), your shutter is slow and your hand shakes, or your aperture is not big enough... so... try to move in closer to the subject. take the shot of up to 50mm (which is about 35mm for a 1.5/1.6 crop factor) and take note of the lighting.
when i started out, i liked to use my zoom to the full... paisey to come close to the subject... but i realized the limitations of doing that in low light situations, so i'm using more close up shots and noticing the lighting.
keep trying... and learning... and importantly... enjoy the process!