Trying to sell you something? Why, does he have a used camera to sell, or this guy also sells Canons exclusively?
Right off the bat, if the guy is telling you to avoid Nikon because they're "not a good brand" - stay away! I don't shoot Nikon but it's not because they're not a good brand - pretty much all the DSLRs are top-notch, each has its own little exception features and drawbacks, but it's certainly not that Nikon is churning out junk. And I don't understand that Nikon "would not have an SLR but they do"???
Second, you can get a DSLR for well under $1,000, from
any of the big manufacturers - Canon, Nikon, Pentax, Sony, or Olympus. Entry-level models from them range from $400-600.
Third - ultimately, you have to keep your expectations realistic. Point-n-shoot cameras are capturing the image with a sensor that's probably smaller than your pinkie nail. It's amazing what they can do with that, but ultimately, you give up quality (both in sharpness and in low-light ability) by having such a small sensor - but consumers want tiny cameras that fit in their pocket, so that's what the companies build and sell. However, a comparable 35mm film point-n-shoot camera should consistently produce better photos, due to the much larger size of the negative vs the sensor in the digital camera. The professional landscape photos you see are probably taken with a medium-format or large-format camera that cost several thousand dollars - you're not going to be able to take a photo that can blow up as large and look as good with a $200-300 camera that'll fit in your pocket. In terms of action sports photos, look at the pros with their enormous lenses - they're not big just for the sake of being big, they are big to let more light in at long distances, in a way that a small camera just can't.
Does this mean that you shouldn't get a small digital camera? Of course not. But just like you can't expect your daily driver to perform like a Formula One car, you can't expect your compact digital camera to produce a poster-size photo with the clarity and quality of a professional one. But you can still produce many nice and satisfactory photos.
A DSLR has a much larger sensor and can be fitted with any number of different lenses, so it is capable of higher quality, but they are bigger,
can be a little more confusing to use, and to get the most out of them, you have to be willing to invest some time into learning the camera, some money into buying lenses (sometimes more expensive than the camera!) and other accessories, and some effort into lugging it all around.