I have gone on record that I do like some modern church architecture, not all to be sure, because most are horrible, but some are nice in the modern sense.
With that said, I like classical and neo-classical church architecture the most. For example, St. Joseph Church in Macon is neo-Romanesque French Revival which was common here in America toward the middle to the end of the 1800's. It is not classical Romanesque in the least.
The Diocese of Raleigh had been planning to build a new cathedral (there current one is the smallest in the USA seating only 300) at the cost of $90 million! However, their fund raising has fallen short as many Catholics today think it is better to build shopping center complexes that cost a whole heck of a lot more, or tall skyscrapers that cost even more to house offices of commerce rather than houses of worship that rival the cost of businesses.
So Raleigh has scaled back their new cathedral to only $40 million. It is still beautiful and I hope the trend of a more classical look for new construction of churches continues. This cathedral will seat 2000. Please note the altar railing and placement of tabernacle (which drives some liturgists to the brink!):