If you're looking to do any kind of artistic work, SLR is a must. Sure, you can get some interesting results on a point-and-shoot camera, but they don't offer the full range of controls an SLR camera does. One thing to remember, though, is that SLRs can become an expensive habit - you'll feel you always need a bigger, faster lens, and you'll need at least 3 or 4 to have a good working range. At first, it's okay to buy cheaper lenses, but as you get more serious about photography, you'll need to buy top-quality lenses to produce stellar work.
As for brands, I know a lot of people shoot with the big two, Nikon and Canon. I work with Nikon for a number of reasons. I find Canons require more work to change settings, but can take some amazing shots with the right lenses. Olympus also produces some really nice results, and so does Pentax.
My advice? Go into a camera store and test different models, and, if you don't know what you're doing, find what feels best when you hold it. Look for a camera with a good warranty and buy from a mom and pop shop as opposed to a big chain store, as I generally find the service is better. They can also give great advice and are less likely to be on commission. Look into the different lines and see what each one has to offer you, and make a purchase when you feel confident. It's a lot of money and an investment, so take your time. You can message me if you have any questions.
J