Yeah, it doesn't get you "high" like pot or other drugs, but it does make you a bit dizzy and perhaps euphoric, often right before the pounding headache starts.
There's a lot of information out on the internet about poppers. The "real stuff" (amyl nitrite) is banned most places since it's a scheduled drug and cannot be sold without prescription. There are a number of chemically similar compounds that you'll find listed in many brands of poppers, such as butyl nitrate and isopropyl nitrite. Do your research.
First, all forms of poppers can be deadly if you have certain heart conditions, take other kinds of nitrates for chest pain, or combine them with ED drugs like Viagra and Cialis, etc.
Second, isopropyl nitrite has been linked to retinal damage, so if you want to actually keep being able to see hot guys, you might want to avoid formulations with it. Unfortunately, other formulations can give you far worse headaches.
Finally, if you are using them, they go bad very quickly so keep them in your freezer (they're alcohol based so they stay liquid) to get a little extra longevity out of them. If they go from a sweet alcoholic smell to dirty sweatsock, it's time for a new bottle.