I have a 2008 Frontier XE that is just like you described (2.5 4-cyl., roll-up windows, King Cab, 2WD, 5psd.). I don't drive much so I only have 34K on it but I've been very happy. My dogs ride in it a lot and the interior holds up. Only problem I ever had was a loose fan shroud which was covered under warranty. Only rattles I've had is a little buzz from the dash for a few miles after driving on very washboard dirt roads. Quiets down quickly.
I get 21-24mpg driving however I want. I bought the 16" wheels and tires off someone with an SE model. Rides really nice and the cab is very quiet and comfortable at freeway speeds. Bed holds my YZF600 or KTM450 but I have to angle the bike to close to tail gate. Bought a bed extender and can easily load my KTM450, CRF230, ramp, stands, EZ-UP, two chairs, portable generator, extra tires, etc. for supermoto race weekends. Area behind the seats swallows my tools, an overnight bag and large gear bag.