To me, the answer is yes and no.
It isn't the typical euphoria one finds while using opiates or MDMA.
Smoking it may feel even disphoric until you're released and feel cheerful to be back after this quantic chaos..
Now I had feeling mostly euphoria when smoking plain leaf bowl everyday ( also at time I was using salvia d. To help giving up too frequent usage of ketamine ). And it helped tremendously in this purpose.
I moved to sublingual tincture which I found first more user friendly and at time very holy happy mood.
But not every time, especially the last few times I used ethanolic tincture ( wasn't using SD often then ).
More recently, I got to try daily microdose of an oil based tincture. So sublingual and oral daily morning doses.
This was very pleasant. Very energizing and highly euphoric but most of the days I used kratom leaves too So there was some possible synergy that pushed salvia euphoria to another level.
In short, in my various experiences, I found more euphoria when using daily, maybe also to work with the plant on a daily basis ( to achieve goal such as quitting a habit, improving ones focus, mood and stamina ).
It is not a push button and nothing is certain with it as long as effects goes.