If you're looking for something like harem, romance, tragedy, take a look at Clannad and other related works such as Kanon and Air. These are pretty good starters.
If you're going towards the...