Your experience will vary depending on the strain and terpene profile of the cannabis you consume.
ALL are positive, some more powerful than others.
I love weed, but there is a caveat. If and how much a person enjoys marijuana can vary depending on the individual, the strain, the quality, their mood at the time of consumption, and the setting.
Some strains will make you paranoid, tired, and slow down your thought process. Smoking (especially certain strains) before an important business meeting or interacting with police/angry, aggressive people is going to be a really bad idea for some people.
Also, like any good thing, it can be abused. For me, if I smoke every day I will start to get forgetful and less motivated. Other people claim to be fine with heavy, daily use though I personally think that they're not honest with themselves.
That said, if you've never experienced being high then I recommend going to a dispensary and getting the highest quality flower available. I recommend an indica or hybrid.
You can smoke it with a pipe, bong, bubbler, joint, or vaporizer. You can also consider edibles though they're not my fave. The high is different and can become too intense and uncomfortable if you eat too much.
Smoking is a better experience imo but if you absolutely hate the smell then try edibles and start with a small piece and wait at least 30 minutes to an hour before consuming more or the high can creep up you and you may feel too stoned if you ingest too much.
Plan something mellow for the first time like watching a movie or walking around a park. If you have a good friend or partner to partake in it with you, that can be nice.
Also, keep in mind that for some people nothing happens their first time. This was true for me, and I don't know why that is.
If you work M-F then try it Friday night so you'll have a couple days to clear your head if you end up not liking it. Some pot, not all, can make me feel a bit fuzzy mentally the day after.
I mess around with it sometimes but I don't like how I feel when I use it regularly for more than 2-3 weeks. I haven't smoked in about a month and will probably go for a lot longer before doing it again. I tend to go on binges with it where I will use it for a month or 2 on a daily basis. The first 2 weeks are great. I feel relaxed and things are good.
After a few weeks of daily use, I start to get forgetful, lazier, and more beta all around. In addition to being more forgetful, I also get stressed out when I haven't smoked for awhile. Depending on how high my tolerance is, it can take anywhere from 2-12 hours of not smoking for me to start to feel annoyed and stressed. Smoking again relieves this feeling, but I don't like that I experience this addictive attachment to it.
Some people claim it's absolutely not addictive, but to me, it is a little bit but certainly not as bad as cigarettes (I quit those in 2010). I have an addictive personality though so it may be different for others.
I also don't do as well with women when I smoke regularly. A lot of women, not all, don't like it and won't date potheads.
With regular use, it also does some weird stuff to my digestive system that's hard to explain. In the beginning it's great. After 2-3 weeks of every day use, my body gives me signs that it's time to take a break.
I smoked a lot in July and August this year. Prior to that I hadn't touched it since June 2017. Like I said, I'm actually enjoying my break from it right now and won't be using for at least a few more months. When I do, I'll do it for a month or so and then take another long break. This is what works well for me.
Tldr: I don't feel like summarizing. Read it or skip.