The saying "the sum of the parts" springs to mind.
Aluminium Alloy, Steel, Carbon and Titanium frames can all be designed for different types of bikes; get that design correct and finish it with the appropriate component choice then they should perform adequately in each role. Many will argue that Aluminium Alloy framed bikes can result in a harsh ride, but you can tune the frame geometry to offer more comfort, tube shapes, tube profiles and design features like
Trek's Iso Speed decoupler can influence comfort, as can larger tyres and a more conservative bike fit, all are valid considerations. Focusing on the riding experience, how much difference each frame material makes for many is down to 'perception'; 'no difference' to one rider maybe a 'deal breaking difference' to another. As an analogy give me the highest quality tennis racket, snooker cue or set of darts and then a more budget but quality version of each and to me they'd probably feel all the same as their higher quality counterparts; I would not have the experience to tell the difference.
As referenced up thread I have two 10 year old Titanium bikes and four steel all aged between 20-30 years old. I like them all for different reasons, as all achieve what they are set up to do. My
Titanium Van Nicholas Yukon and my
winter steel fixed are the two I use the most, the latter simply because it's my commute bike, the former as it is by far my favourite bike to ride. My Yukon offers the perfect blend of super smooth comfortable ride, performance and light luggage carrying capabilities that suit my type of cycling. The riding experience is not the only consideration, for me personally I am influenced by robustness, aesthetics, price, and desire to name but four. I use my Titanium Yukon for touring and yes the riding experience played a massive part in why I chose it, but it doesn't lead a precious life, so the robustness was an attraction, as was having no paint to chip!
Referencing 'desire' to quote 'Hedgemonkey' "A titanium purchase will more than likely be made with very unscientific reasons, I just think it will be nice to own one"; for many a bicycle is not just a tool to go cycling on it's something they find pleasure in owning; something they buy with their heart as well as their head. I am someone who doesn't 'treat' myself very much on every level, as you can see from how long I've had them that includes my bicycles! But, this was an occasion my desire for wanting them was so great that I indulged and treated myself. In someways the fact that I do that so rarely makes it more special when I actually do. My Yukon reminds me of holidays and the life affirming memories that often go with them. I adore how it looks, I adore how it performs and I adore how it makes me feel.
I keep my two Titanium bikes in my bedroom, I love cycling and I love bicycles, they are my two wheeled friends, I smile every time I look at them and every time I ride them. So in conclusion 'Hedgemonkey' when I take into consideration the sum of their parts, "Is Titanium really worth the extra cost over a nice good steel frame", for me
personally; yes it was.