The pants that work best for you will depend on your build...so the best option is to go to the shop and try on a bunch until you find what works best.
That being said, I find that Levi's 501 jeans work great for me. Keep in mind that (a) lighter colors show off better, and (b) the stonewashed colors will "break in" more quickly, thinning out in the crotch, becoming more comfortable, and showing off more.
A good pair of slim-fitting khaki pants works really well, with the property again that the thinner, finer, and lighter-colored the fabric, the more it will show off. Of course, these are a little more dressy than denims.
When you find pants that work, you're going to have to share photos, of course