I have reviewed all the other questions on SE regarding the skyscraper sheaf and I believe my question is not a duplicate. I am also aware that the questions I pose below may be considered ill defined since there is not 'one right answer' - if my question gets closed, so be it - but I just started learning sheaves and they are complicated. With a complicated object like a sheaf, I like to discuss these sorts of things early on with people who have more maturity on the topic to make sure I am interpreting the object in a good way. Please at least skim my high lighted questions to avoid just answering the title, which does not encompass all of my related questions.
I have mostly been working with sheaves of abelian groups, but answers involving sheaves that take values in any concrete category should be understandable to me. Probably best to avoid examples and answers involving abstract sheaves that take values in complicated categories like Cat.
First of all, there are two definitions of a sheaf. The more modern/common is the functorial definition given on wikipedia, and then there is the étalé space definition given by Serre on the first page of FAC. I give this definition in the questions I asked here, and here. The definition Serre gives is the one I have been using, but the discussion in the comments on the second link briefly discusses why they are 'equivalent'.
Some of the explicit sheaves I have encountered that have names seem to make more sense using one definition than the other. For example, the constant sheaf makes more sense to me using the étalé definition, and the skyscraper sheaf, so far, seems to make more sense using the functorial definition. The skyscraper sheaf is the one I would like to discuss.
The standard definition given for the skyscraper sheaf (using a sheaf of sets for simplicity), such as in Vakil's notes, is as follows.
For a topological space $X$, and a fixed point $x \in X$, and some set $S$, for each open set $U \subset X$, we assign the set of sections
$$F(U) := \begin{cases} S, &\text{ if } x \in U,\\ \{e\}, &\text{ if } x \notin U. \end{cases}$$
For sheaves of algebraic objects replace $\{e\}$ by the appropriate terminal object in the category of choice.
One can check that the stalks of this sheaf are $$\mathscr{F}_y := \begin{cases} S, &\text{ if } y \in \overline{\{x\}},\\ \{e\}, &\text{ if } y \notin \overline{ \{x\}}. \end{cases}$$
Now we are prepared for questions.
1. Do some skyscraper sheaves not live up to the name?
How I think of a sheaf intuitively, or decide what a sheaf should look like, is pretty much determined by its stalks. This makes sense since I use the étalé definition where the actual object that is called the sheaf is the disjoint union of stalks, as opposed to being the functor that determines such data. Now if $X$ is T1, or more generally $x$ is a closed point of $X$, I see that if $S \neq \{b\}$ we get one non-zero stalk $\mathscr{F}_x$ and all other stalks are $\{e\}$. However, if $S = \{b\}$, or if we are in the algebro-geometric case where the space $X$ is usually not T1, $x$ could be a generic point so that its closure was the whole space. Then no matter what $S$ was, every stalk would be $S$. These are two different ways that a, by definition, skyscraper sheaf could turn out to be a constant sheaf. Is there a way I am missing to still interpret these sheaves as skyscrapers, or are they just perverse examples that don't live up to the name?
In my next question, for simplicity, I will speak as though $X$ is T1 so that the skyscraper sheaf has exactly one non zero stalk (so $S \neq \{b\}$ also).
2. Is a skyscraper sheaf actually 'tall', or is it just tall compared to everything else around it?
When I first heard the name 'skyscraper sheaf' I automatically thought I was about to encounter a massive object like the monster group. However, since I 'picture' a sheaf as a collection of stalks, it doesn't seem that it's one non-zero stalk at $x$ needs to be necessarily 'tall' or 'big'. Since the stalk is a direct limit, and direct limits tend to make bigger things out of smaller things, I first thought maybe I would be getting lots of copies of $S$ for the stalk at $x$, perhaps one for each open neighborhood, which will (maybe) make that stalk very tall. But I quickly thought through this and realized the direct system determining that direct limit is just the identity maps and the same object over and over, yielding the same object for the direct limit, so this can't be why the one non-zero stalk would be a 'skyscraper'. I tend to think of the 'size' or 'height' of a stalk as its size as a set, or group, etc. So if I chose $S = \{a,b\}$ for my one non-zero stalk, by definition I have a sky scraper sheaf, but really to me this is more like a mole hill sheaf because the stalk corresponding to $S$ would not be very tall, even compared to all the 0 stalks around it. But maybe if I quit thinking about a sheafs physical interpretations as only being determined by stalks, I could also consider stalks and sections. Then, even if I choose $S = \{a,b\}$, I have a copy of $S$ at $x$, then as I transition from local to global, taking nested open subsets containing $x$, I get a copy of $S$ for each one. Maybe this is how the sheaf is 'tall' around one point? Then if I do this process anywhere else, my sequence of sections would be 0 until the open subsets were big enough that they also included $x$ (yes, I am not abstractly thinking of the topology, and am thinking of it as being 'like' a euclidean topology or a Hausdorff space, but oh well).
3. Is it possible to define a skyscraper sheaf and end up with something more like an “NYC Sheaf"? As I mentioned above, if $x$ is a non closed point, we could get more non-zero stalks on the closure of $x$. Above I mentioned an extreme case from the Zariski topology where a point may have the entire space as its closure. Are there any naturally arising cases or examples where the closure of a single point is not the whole space? In this case we should have non-zero stalks on some closed neighborhood around $x,$ and then 0 everywhere else. I imagine if I stood back and looked at this sheaf it would look kind of like this arial photograph of NYC where the angle and distance of the photograph make it look like a ton of action packed into one (seemingly) small area, then flat everywhere around it for as far as you can see. This sheaf should be called the NYC Sheaf!
Lastly, it is a perfectly acceptable answer that I will gladly upvote (if it is true) to say "It seems your understanding of a sheaf, and a skyscraper sheaf, is adequate and you are horribly overthinking the name. Get back to proving theorems.