Thank you all very much! I didn't think I would get so many detailed responses. I read every single reply and you've given me a lot to think about. I appreciate your honesty. :sadsmile:
Some of your stories had me laughing (especially how many of you mentioned never peeing alone again

), and honestly shelties don't sound bad at all. From what I'm understanding, where you get your sheltie and how you train them early on is probably the most important for getting a well behaved, easy to live with dog - but the same could be true for any breed so I don't feel intimidated by what I could be in for anymore.
I think there was a question in there somewhere as to what training methods I use; I clicker train exclusively. I find it rewarding to sit down (or run around) with an intelligent dog and seeing the light bulbs go off in their head as they try to figure things out.
I'm going to specifically quote Dr. Shelli's post because she basically described exactly what I'm looking for in better words. (It's also the post I just read so I remember it in detail better, lol!)
When we are training, they are active ,engaged, responsive and ready to go. All of them can wait their turn in a calm manner.(...) When I am at home and not doing anything with them they chill and usually sleep.
This to me is ideal. I would love a dog that is ready to go (like a furry rocket) when I am, but also has an off switch when I have to work on other things. I like to do something and train every day with my dog and if they aren't enthusiastic too, I don't have as much fun.
The off switch concept: I don't know if that's something only some dogs are born with or if it's trained, or both? I haven't raised enough dogs to know. I know there are ways to "capture" calmness, and/or teach them to lie on a mat or special spot when you need a little space. My last dog was automatically relaxed in the house and chose his own special spot in front of the door (like I mentioned he was a watch dog who barked at leaves) when I couldn't pay attention to him, so I never had to consciously use any of those methods. I'm guessing with some shelties you have to?
You need to get a sheltie form stable parents and good lines. No not all pups from big well known breeders(performance and show) fall in the category I am afraid. Anxiety is rampant in this breed and it leads to all the behaviors people fault shelties for(reactivity, hyperactivity, nonsense barking, oversensitivity etc) Do you research, met the parents, ask about how the puppies are socialized and be prepared to walk away if you don't like what you see.
Ok, this explains it really well. A few of you mentioned this and I expected that it had something to do with various lines and early training but I needed to hear it.
So my understanding of this (or misunderstanding!):
Shelties should be alert like a typical watch dog, and will bark at things they think are out of order. That's what they were bred for. But they shouldn't be overly sensitive; Anxious behavior like spinning, reactivity to normal household noise might have to do with their genetics and/or how the shelite was raised.
Since I have an untrained eye for shelties, if I were to visit a breeder what should I look for to avoid lines with nervous issues like that? Besides avoiding spinning dogs.

I'm not sure where to start with this.
I actually do not like Goldens at all because they are too needy. I do admit the dogs I tend to chose for myself are very focused and responsive to people but are not in my face or submissive. I like the outgoing confident responsive pup, I broke that rule with Ember and we didn't gel for a long time.
Yes! Ok, this is basically how I feel. I have met shelties that were the "strong silent type" (as one of you called it) and I think that describes what I like pretty well.
So if I understand correctly, shelties like to follow you around and be in the same area as you, but generally give you a bit of space, especially if you don't let them manipulate you into giving them attention when they demand it? If so that sounds fine.
Forgive me as I'm having a hard time describing this "neediness" quality that I don't like. And I think some people were asking for clarification on this.
I do want a dog that likes to interact with me, but isn't insecure or doting and needing to be picked up, touched, or cuddled all the time. I do like to cuddle with my dog sometimes, but when in the house I prefer if they are just "around" doing dog things most of the time. If they want to watch me doing stuff that's totally fine.
I don't mind a dog following me around or coming up to me while I'm working. I think it's when they don't seem to have a mind of their own? When they can't lie down without being right there, touching your leg (sometimes is fine), or can't sometimes play with their toys without you? Does this make sense at all? It's not the loyalty, it's the "I can't do absolutely anything without you" attitude that it seems a lot of toy dogs have bred into them (correct me if I'm wrong).
[Barking] It does vary by dog. I can usually tell who is going to be more vocal right from the start.
Is it something that's obvious? I've read here that some shelties can be quiet when they are puppies and then "find their voice" on maturity. Nature vs. nurture?
If I had a sheltie that barked at dog sports I wouldn't care. Especially if I did flyball again because all the dogs bark anyway! It's the anxious reactivity and separation anxiety that I'm worried about. From what I can gather from all your information, HOW reactive a sheltie is to noise can depend on the lines they are from? If that's so, where do I begin with researching that?
Do not let them dictate your schedule(I don't have one so my dogs go with the flow and don't get demanding for meals etc) I think they are the master manipulators and will rule if you let them. Fair, consistent structured expectations of what you want should be the rule. Not that my dogs are little robots but the things that are important to me I don't say to myself just this one time(because it will happen again if the dogs enjoyed it)
I completely agree with this philosophy and have found it to be true of other breeds too, if not all dogs... that "just this once" is a trap! It's so much harder to undo things once they learn it works (even if 0.1% of the time!). I made mistakes like that with my first dog and am more aware of it now.
This is getting really long and I may have asked the same question twice. If anyone has any thoughts that would be great.

Thanks again for your help!