I've experienced both types.
Had one in a spa attached to a 5 star hotel. The masseur was beautiful. Rather than being relaxing I was constantly thinking please don't go up.
Also have experienced tantric massages with a lady who visits belfast every month. They are very sensual but relaxing. Always have a happy ending.