Out of the species I own I can tell you that while I love Sand Boas, Hognose and BP they make very poor display snake, you can have the most elaborated display and you will never see them. So what do I love about them, I love their personalities, paint job and snakes have always been fascinating to me, but if I really want to see them I have to spend the time and handle them.
Now as far as display animal arboreal and semi arboreal species will make the best display animal.
So it comes down to the owner's expectation really and what matters to them. My only displays are actually not snakes but geckos.