As others have said, it's changed (no pun intended) for me over time.
When I was a teenager and just starting to experiment with diapers, or more so with wet pants and makeshift diapers (multiple pairs of underwear, towels/washcloths, paper towels, trash bags, etc.), it all focused around the sexual aspect. The only reason I was doing any of it was because it turned me on and as soon as I came I was done.
Now, I will wear to wear, sometimes going through several changes before showing and putting regular underwear back on. I do generally masturbate before taking my last diaper off, but I change out of it pretty quick not because I feel shame or gross but because that's what I planned to do anyway. Sometimes I'll fall asleep in it and then pee once more when I wake up, before hopping in the shower.
As a teenager I definitely considered myself exclusively DL/TL but now I've developed a little side too, so sometimes my diaper wearing is part of being in my little space.