This is really difficult to analyze without any reads or numbers on villian except he is "certainly tight". He is the third player to limp so this could be any number of hands that include small/med PP and connectors.
You flop bet was fine IMO, a good size(75% not 90% btw) and a check would only be for C/R reasons which with so many people I dont see a bluff here, maybe an extra bet from a AJ or KJ.
After that this is just a shitty situation on the turn, his 3/4 pot bet is a time you have to start thinking of any reads you might have. Since you have 2 pair its unlikely he has 99 or JJ here. I dont think you can dismiss a draw here, with players left to act maybe he thought there could be another caller giving him good enough odds
, who knows. Depending on his numbers this could be a fold but that would be a tough fold. Another option would be to throw out another bet here and fold to a raise considering you label him as tight? I just dont know.
I would not make a 30 big blind blocking bet just to fill your ego and see that he had a set, while a blocking bet has its purpose that shouldnt be one of them. I am probably checking this and folding to anything too high. Unless he is a maniac, which it doesnt sound like he is, I cant see your hand being best with him having the chance to check it down with 4 to a straight on board. What is he going to call your bet with that you beat? I also cant imagine getting a set or better to fold here even with 4 to a straight. I could be wrong here though blocking bets are something I probably dont get enough value out of.
Overall a shitty situation good fold on the end.