I can recommend StackEye, a Chrome extension that allows one to follow SE users (as well as particular questions). It adds a Follow button to each user's profile:
The notifications on the extension icon are an unobtrusive number (not some flashy-red thing). Upon a click, you get a list like this:
Although not see on the screenshot, questions asked by followed users are also included in notifications.