For Masses in English, I like the Daily Roman Missal published by
Midwest Theological Forum.
As a church musician, I sometimes need texts
for weekday or Saint-day Masses in addition to Sundays but it is not
convenient for carrying to church, since it's two inches thick.
For a Sunday-only Missal, the Saint Paul Sunday Missal (Pauline Books) looks
handy: it has an attractive typeface and is only about 3/4 inch thick.
If you're interested in Latin Masses in the old form, you might consider getting a used copy of the Fulton J. Sheen Sunday Missal, published in
1961; they're beautifully designed and about $80: too bad nobody has
started offering a new edition.
If you want to get a brand-new Missal,
it may be hard to find a Sunday-only book; I don't know of any.
Press has an attractive Roman Catholic Daily Missal for about $65.
I hope this will be useful. God bless!