At first when I was looking at my weed usage in the past I was only focused on the negatives. Recently I realized that weed really helped/made me become interested in several different things over the years I used it regularly. I thought maybe something else changed that made me lose interest, but when I started smoking again I noticed my motivation slowly came back. These things(hobbies I guess) included programming(web, games, visualizations), music production, animation, and photography. Also general wikipedia reading, especially related to the brain and pharmacology. These things still interest me when I haven't been smoking, but it is pretty obvious that the driving force behind getting proficient and constantly fiddling around with them was from weed.
Of course there are tons of people that smoke regularly and all they do is watch tv shows and such.. so I guess your mileage may vary. I would think the important part is to find constructive things that you would enjoy doing high and that way you won't start sitting around doing nothing.
For me strains&sativaVSindica don't seem to make that big of a difference, I prefer sativa, but pretty much all of the weed I've had has a similar benefit. Don't get "stupid" high. Trial and error might be the best way to see how much you really need to smoke to get the positives.
To me it looks like very small amounts of cannabis can be helpful and sometimes even motivate to do things as you have experienced yourself. So it would be not about getting high, it would be about 'teasing' brain a little and thus making it more active.