The point of topology is not an easy one to grasp. A way I always introduce topology is by the following two theorems:
Theorem 1: If f:[a,b]→R is a continuous function, then f([a,b]) has a minimum and a maximum.
Theorem 2: If f:[a,b]→R is a continuous function and if a<0<b, then there exists a c∈[a,b] such that f(c)=0.
This is all very well, but how can we generalize this?? The domain in both function is one-dimensional (i.e. subset of R). What if we want a 2-dimensional domain?? What if our domain is a sphere??
These questions ask for a general treatment. That is, we might ask ourselves: under what circumstances stay theorem 1 and theorem 2 true?? Research of this fact was being done, and the conclusions were that the domain in theorem 1 should be compact. And the domain in theorem 2 should be connected. So we get
Theorem 1: If f:X→R is a continuous function and if X is compact, then f(X) has a minimum and a maximum.
Theorem 2: If f:X→R is a continuous function and if X is connected, then f(X) is connected (= an interval).
However, the definitions of compact and of connected are not at all easy. Even right now, I have still no intuition about why we define compactness the way we do. I know that it works and I know why it works, but it's quite mysterious.
I think the motivation for topology is the old story about doughnuts and coffee mugs. And that's sort of what topologists proper actually study (except algebraic topologists are even dumber and can't tell the difference between things that have the same homotopy type or maybe things that are weak equivalent). Topology, from an analysis point of view is a bit different, but the way I think of it, it consists of the observation that things like function spaces also have a topology that you can study, just like surfaces or manifolds do (which roughly means they can be viewed as stretchy things). Functions spaces sometimes have a metric on them, so distance makes sense, and once you have distance, you can forget some of that structure and you have topology. And metric space topology isn't much different than topology of R^n, say. The gap in my understanding here is that I don't have very good examples of topological spaces that aren't metric spaces. I can cook up examples, but they aren't very interesting. So, if I knew more analysis, I could probably say it's useful to try to generalize topology to things that don't even have a metric.
Connectedness isn't that unintuitive of an idea.
Compactness is fairly non-intuitive. But the original compactness was sequential compactness, which isn't so bad, once you know a little real analysis. Sequential compactness DOES make sense in any topological space. So, while this isn't the best motivation ever, you can get some motivation for the concept of compactness this way. Sequential compactness is equivalent to compactness for metric spaces. Furthermore, for some constructions, compactness, in the open set formulation proves to be very useful. It's good for patching local information together to get global information. So, you learn of its importance while doing some proofs. Now, you could just define compactness to be sequential compactness, but the present definition of compactness is more general. So, it allows you to have that nice open set property to work with for your proofs, but is a weaker requirement on your space. So, if you want the most general setting in which you can do those kinds of local to global arguments, you want the present definition of compactness. But all this kind of assumes you are pretty comfortable with weird, but useful non-metrizable topological spaces, for which you'd like to say are compact, even though they happen not to be sequentially compact.
I'm a topology student who cares mainly about manifolds, so I don't really need the really ugly spaces that come up in analysis. So, basically, I suspect when you learn a lot of analysis (more than I know), you can really appreciate the motivation for point-set.