My most "stand out" palm is one of my two Needles. Thankfully, the stronger of the two (planted at the same time from the same batch) is in my front yard while the runt in is the back yard. In 2007, it was a single-stem, 1-gallon plant that I hauled up from Virginia Beach. Twelve years later, it is a multi-trunked, 6-foot tall monster. In its earlier years, it suffered many minor setbacks. Broken petioles from snowfall, spear pulls every other winter. That kind of thing. I used to come on the board here and complain about it. PJ from Maryland would tell me, "One day, you will love that palm." He was completely right.
The other two palms that have been impressive, but not with the same shock and awe of the Needle are a Sabal Birmingham I planted where I work and a Sabal Minor 'Hatteras' at home. The former for its resiliency and ability to take winters here with no protection except mulch, and the latter for its HUGE fronds.
Arborescent palms just don't make it here, short of being sited within amazing microclimates.