Hi Sophia, great question and I'm sorry that you have not gotten any concrete answers from anyone. I have a couple points I'd like to make to help you out.
1--The films you're going to want to use are Kodak Gold 800, Kodak Portra 800, Fuji Superia 800, Fuji Pro 800Z and Fuji Superia 1600. The Fuji 800 and 1600 are often not available anymore in the US but there are still canisters on eBay etc. Fuji Natura 1600 is the Japanese replacement for Superia 1600 and is expensive. Another thing you can do, is push process a film like Kodak Portra 400 to 800, 1600, or 3200 ISO. I often simply rate Portra 400 at 1600 and don't bother to push and it works out great. If you want big grain, consumer grade 800 ISO films like Gold and Superia will be perfect.
2--I am an available light 35mm photojournalist so I totally get what you are trying to do and I admire it. Flash spoils candid moments and film can add a beautifully compelling feeling or atmosphere to an otherwise commonplace scene. The problem is, however, that there are no still photography print films made in tungsten balance. There are some tungsten balanced E6 films but they are pretty slow and are unlikely, even when pushed to get as fast as you need them. If you are unfamilar with white balance, you basically need to know that most colour films are balanced for daylight. So they look great when shot under sunlight but shift to orange when shot in most types of artificial lighting. Film companies expect you to get the correct colour by using a flash, using a filter or allowing the wide latitude of print film to get the colour pretty close through editing. It's very very difficult, however to get accurate colour on film without a flash. For these reasons, many film shooters use b&w in dimly light situations or just rock the funky colour.
3--Don't forget that the rules all change if you are willing to use a tripod or drag your shutter. You can use 100 ISO film in the middle of the night if you are okay with motion blur or bracing your camera. And has also been said, a fast lens is useful but then you have to deal with crucial focus being potentially lost. I use a 50mm 1.2 and nothing slower than a 105mm 1.8 in 1600 - 6400 ISO lighting conditions. But I try to stay off the widest aperture unless absolutely necessary else, I'll focus on a nose instead of an eye.
4--I truly understand and appreciate your passion for film photography, however, to say that clean, well-exposed, finer-grain film photos look like digital photos is rather silly as there is just so much more to film photography than poorly exposed images that are gobbed up with grain and weird colours. For me, I am for clean, correctly executed images and then allow the chaos of the moment to define the photos that I fall short of this goal with. And to me, this is where film is fun, knowing that even the mistakes or failures can look great. If you want things to look "bad", all you have to do is use common 400 ISO film like Gold 400 and rate it at 3200. Your colours will be drab, your shadows will be grainy and your contrast will be flat. And if this works for what you are trying to say as an artist, great! But I just encourage you to also look beyond that and see what quality film can also be capable of.
5--The photo you shared was taken with a 400 speed print film. The colours shifted to yellow/orange for the reasons stated above about white balance. Beyond that, there is nothing unusual about this image. The photographer simply found a situation where the lighting was good enough in a dark situation to get by with this photo. They may have used a tripod or sat the cam on a countertop to steady it and use a slower shutter speed.
6--Here are some examples that I have taken that I think you may find appealing/useful.
http://www.flickr.com/photos/johnnymartyr/8298827591/in/set-72157623882514305
http://www.flickr.com/photos/johnnymartyr/8401833282/in/set-72157623882514305
http://www.flickr.com/photos/johnnymartyr/350920958/in/set-72157625149345465
http://www.flickr.com/photos/johnnymartyr/4437816232/in/set-72157625149345465
http://www.flickr.com/photos/johnnymartyr/3657225103/in/set-72157625149345465
http://www.flickr.com/photos/johnnymartyr/5619727912/in/set-72157625149345465
http://www.flickr.com/photos/johnnymartyr/5329950435/in/set-72157625149345465
http://www.flickr.com/photos/johnnymartyr/5449781335/in/set-72157622920616526
http://www.flickr.com/photos/johnnymartyr/4416440528/in/set-72157624287322185
http://www.flickr.com/photos/johnnymartyr/4524819051/in/set-72157622920616526
That last shot is at a Starbucks
Please email me at JohnnyMartyr@Hotmail.com with any questions!
METAL AND MANUAL! FILM FOREVER!