If you want to show, then first you need to decide venue as that will dictate which type of show line dog. If AKC/CKC type shows, you want a dog from American show lines. Whether you want a dog to do well in the specialty ring vs just overall in the all breed ring will then further narrow the options of what type of American show line. If SV style shows, you want a dog of German show lines. Also be aware that within the SV show system, it is expected (and required after a certain age to show in the main classes) that the dog be titled in SchH/IPO or HGH herding. So you would also need to participate in one of those, or find a trainer to train and title your dog, to do SV showing.
Either type can produce an excellent candiate for the rest of what you are seeking in terms of personality.
Holland's recommendation of going to see some shows of both types, where you can get more familiar with what the shows are all about and also meet dogs in person to get a good idea of what they are like, also networking with breeders and fanciers of the different types, is the place to start.