I think the most important question is how stable you think your relationship is with your fiance. The program is actually a very decent program on paper given the patient load, pathology (transplant), and subspecialty representation, despite being "community", and you will be able to have excellent training there. Just being in a "prestigious" program does not make you a great neurologist, and it really comes down to how much you study and learn through residency, and I've encountered good and no-so-good neurologists coming from both community and more academic programs.
At the end of the day, it seems that prestige is still something you value, and you are sacrificing this for the benefits of your fiance. Residency is temporary. Is he willing to make the sacrifice of being away from hometown for 4 years for you? 3 hours are also not that far. Can he make the sacrifice of visiting you frequently despite the 3-hour commute (to make it less "long-distance")? If you make the sacrifice for him to be in the community program and you are not happy in this program for whatever reason, would you carry resentment or think about "what if's"? Residency is pretty grueling sometimes, and if you are not happy in this program after making the sacrifice, would that affect your relationship with your fiance?
Just some things to consider, especially heart to heart with your fiance.