An augmented fourth sounds great as long as it is then resolved e.g. to the fifth. See "Maria" from West Side Story[1] for the probably the most well known use of an augmented fourth. The first interval when he sings "Maria" is an augmented fourth.
[1] http://www.youtube.com/watch?feature=player_detailpage&v...