Depends on the size of your butt!! Skinny jeans do not suit large people, but if you are size medium or smaller, the tighter the jeans the better. However, you should not wear jeans that you can't fit two fingers under the belt while they are on, otherwise they might cause internal injuries in the long term.
Well I don't think you can make them tighter but you can buy super tight ones to begin with. Legging jeans (tight) or even jeggings (super tight; get good ones that look like jeans, not leggings (unless you want them to)). They're in a lot of stores. I get mine at Abercrombie and Hollister and I love them.
Stretch jeans mostly provide better comfort and allow for a smoother, tighter fit on a wide variety of body types. A bit of stretch in the fabric is particularly important in jeans for fuller-figured women, giving them the fitted appearance that elongates the body, but it can be found in jeans for all body types.