I'd say the effect was very minimal, especially since the tags would often be part of the title and therefore already in the URL.
One thing that is a little more effective, is putting better keywords closer to the beginning of the title, e.g. "url - Including tags in question URL". You can do that quite easily in a custom theme by overriding the title function (called title() or page_title(), I forget).