25mg is already enough to make you sleepy. It is an antihistamine so no euphoria. In high dosages you will just experience anticholinergic toxicity such as delirium. Nothing pleasant.
Promethazine is just used sometimes with opioids to enhance the nod as it is a sedating antihistamine. That's about how useful recreationally it can be.