You're either using your bathroom wrong, or have a vastly more interesting sex life than I do.
(Yeah, I missed the kitchen counter on first reading)
The reason we went for it because it appears to be the only way to get a light-colored stone countertop that won't stain when you spill red wine or tomato sauce on it. It has been excellent, hasn't picked up any stains at all.
If it's not an investment, don't go into debt. And a premium finish is not an investment, unfortunately. If you sell soon, you won't recover the cost. And if you sell down the line, it will be out of fashion regardless of how well it physically held up.
By all means splurge on yourself if that's what you want! Just don't justify it by framing it as an investment that you should be taking on debt for.