I believe the op is talking about some sort of nitrate compound such as amyl nitrate or more likely butyl nitrate or isopropyl nitrate as amyl is illegal in many places.
As far as "poppers" go they can be fun during sex, and some people (not including me) like to take them on ecstasy while listening to music. They give you a kind of head rush but not much else. Also when they wear off you might be left with a headache.
We can't really tell you if you will like a drug or not. You can only find this out by trying for yourself.
Some people like to use them during anal sex because they dialate the blood vessels or possibly relax the muscles making anal penetration easier. They are very popular among gay males.
It is very dangerous to use any nitrates if you have taken Viagra or cialis type drugs. They both lower the blood pressure and can lead to fainting, heart attack or stroke.