You can always impose artificial constraints to add more time sinks but that’s on you and your ego not the game.
I don't know about Terraria, but only speedrunners consider the end dragon to be the final boss of the game. Besides the fact that the game has received regular updates with new content (and harder challenges/bosses) for more than a decade since the dragon was added, it's a block game...
> unless you just want to build stuff at the endgame
That's like saying "unless you want to build things with lego." Building things is the point, it should go without saying. Beating the dragon is what players do in the first day playing on a new map to clear the way for the real gameplay. It's a prerequisite (not finish line) for getting a full set of equipment so you can start building in earnest. Beating the ender dragon is like getting the box of legos open and poured onto the floor.
Meh. There’s plenty of modern games where “winning” either is not really a thing (Minecraft, Terraria, dwarf fortress) or is fiendishly difficult (“winning” StS would be semi-reliably killing the heart with any character at maximum ascension, I think just reaching A20 in 50 hours would be impressive).