a good picture is a good picture no matter the size
i don't think smaller prints have a more intimacy effect than bigger ones, i can feel intimacy to 3x2m print if the photo gives me that. Big prints let the observer play more, you can move far far away and see the whole frame, you can move quite close and see details, to me it's like a game. Smaller prints doesn't give me that, two steps forward or two steps back that's all.
i don't think neither that huge prints are not good enough technically. i can recall big prints with gorgeous technique (dijkstra, jeff wall, even latest work from leibowitz,...). What i can't stand is ugly and stinky art in museums or galleries and it has nothing to do with print size. The trend now is big but those mundane objects were bad in the eghties also...